Sammlung von Newsfeeds
Pavel Stehule: using jq for processing PostgreSQL logs in json format
PostgreSQL supports logging in json format. From my perspective json logs are badly readable, but allows machine processing, and with good tools, it is beautifully simple.
There are more tools for json processing - I use jq.
For simple analyze of errors in log, I can use sequence of commands:
Jeremy Schneider: Postgres Indexes, Partitioning and LWLock:LockManager Scalability
I have decided that – in Postgres circles – I shall henceforth refer to 2023 as THE YEAR OF THE LOCK MANAGER’S REVENGE.
Let me explain.
Gabriele Bartolini: CloudNativePG Recipe 1 - Setting up your local playground in minutes
Dive into the world of running PostgreSQL in Kubernetes with CloudNativePG in this inaugural guide. Follow along as we walk you through the process of setting up a disposable local cluster using kind. Gain insights into creating PostgreSQL clusters, installing CloudNativePG, and leveraging the cnpg plugin for kubectl. Wrap up your journey by tidying up your local cluster.
Claire Giordano: What’s in a name? Hello POSETTE: An Event for Postgres 2024
When I think about naming something—like a feature or product or even an event—this quote always comes to mind.
What’s in a name? That which we call a rose
By any other name would smell as sweet;
–William Shakespeare
What’s in a name, after all? I’m no expert on Romeo and Juliet, but friends tell me Shakespeare’s point was that names don’t matter. The thing itself is the thing itself, regardless of the name.
Ryan Booz: PGSQL Phriday #016: Tuning That One Big Query
Gilles Darold: Partitioning by reference – Oracle vs PostgreSQL
Sometimes, when you are working on a migration to PostgreSQL, you can encounter features that do not exist in PostgreSQL. This especially happens when we do not have any extension to emulate the feature you are looking at. At HexaCluster Corp, we often face these kind of situations. When it is possible to create an […]
The post Partitioning by reference – Oracle vs PostgreSQL appeared first on HexaCluster.
Francesco Tisiot: List of PostgreSQL® AI Projects and Resources
Everyone is now talking about AI, and modern databases like PostgreSQL® are increasingly being adopted in companies' AI journey as sources of data or key pieces of the AI infrastructure. Moreover there's a new set projects that are solving PostgreSQL problems with AI.
PRs are welcome!
Gilles Darold: PostgreSQL security – Password Reuse Policy
A database password reuse policy is a set of rules that govern the use of passwords within a database system. The policy is designed to ensure that users create strong and unique passwords, and that they do not reuse the same password. By implementing a database password reuse policy, organizations can reduce the risk of […]
The post PostgreSQL security – Password Reuse Policy appeared first on HexaCluster.
Ryan Lambert: Can you use ltree for Nested Place Data?
The topic of the ltree data type has come up a few times recently. This intersects with a common type of query used in PostGIS: nested geometries. An example of nested geometries is the state of Colorado exists within the United States. The PgOSM Flex project calculates and stores nested polygon data from OpenStreetMap places into a handful of array (TEXT[], BIGINT[]) columns.
Ari Padilla: Podcast about transitioning from developer to PostgreSQL specialist, with Derk van Veen
How do you feel when your day doesn’t go as planned? In this episode of the Path To Citus Con, the podcast for developers who love Postgres, guest Derk van Veen joins co-hosts Claire Giordano and Pino de Candia to talk about his journey from Java developer to Postgres specialist.
Tobias Petry: First Row of Many Similar Ones
Francesco Tisiot: 11 Lessons to learn when using NULLs in PostgreSQL®
A boolean value should only contain two values, True or False, but is it correct? Usually people assume so, but sometimes miss the fact that there could be the absence of the value all-together. In databases this is absence is usually stored as NULL and this blog showcases how to find them, use them properly and 11 lessons to learn to be a NULL Pro!
Keep in mind, it's not only booleans that can contain NULL values, it's all the columns where you don't define a NOT NULL constraint!
Gabriele Bartolini: Maximizing Microservice Databases with Kubernetes, Postgres, and CloudNativePG
Explore the synergy between PostgreSQL and Kubernetes through CloudNativePG — a transformative operator discussed in this article. Discover how this powerful open source stack empowers organizations to free themselves from vendor lock-in and to create a seamless microservice database environment, enhancing innovation, operational efficiency and velocity. This article provides a refreshed perspective on “ Why Run Postgres in Kubernetes?” from 2022.
David Wheeler: Extension Ecosystem Summit 2024
I’m pleased to announce that some pals and I have organized and will host the (first annual?) Extension Ecosystem Summit at PGConf.dev in Vancouver (and more, see below) on May 28:
Akhil Reddy Banappagari: AUTOCOMMIT – Oracle vs PostgreSQL
Oracle and PostgreSQL differ significantly in their transaction models, and AUTOCOMMIT is one of those differences. We see many of our customers successfully migrate code, but still encounter variations in behavior and even runtime errors related to transaction control. Many issues happen because AUTOCOMMIT settings differ between Oracle and PostgreSQL. It is definitely necessary to […]
Deepak Mahto: Uncovering and Exploring ROW Constructors in PostgreSQL.
A ROW expression allows you to construct ROW values, which can represent anonymous records, specific table row types, or custom composite types. Its uses include processing records within multiple expressions (using operators like =, <>, <, <=, >, or >=), evaluation with subqueries, and combining ROW values to build composite types. You can even export these to JSON format (using functions like rowtojson). Some key operations you can perform with a ROW constructor in Conversion or migration are :
Devrim GÜNDÜZ: Installing PostgreSQL on SLES 15 just got easier – and better!
The PostgreSQL RPM repository for SuSE Enterprise Linux has supported SLES for quite some time. We followed the usual conventions and used zypper addrepo … to add the repositories.
Continue reading "Installing PostgreSQL on SLES 15 just got easier – and better!"
Umair Shahid: The default value of fdw_tuple_cost was updated to 0.2. What does that mean?
This blog post explores the recent change to the fdw_tuple_cost parameter in PostgreSQL, examining the problem it addresses and the reasoning behind the new default value (0.2).
The post The default value of fdw_tuple_cost was updated to 0.2. What does that mean? appeared first on Stormatics.
David Wheeler: Extension Ecosystem Summit 2024
I’m pleased to announce that some pals and I have organized and will host the (first annual?) Extension Ecosystem Summit at PGConf.dev in Vancouver (and more, see below) on May 28:
semab tariq: Understanding Indexes in pgvector
Explore how pgvector's indexes work, choose the right one for your needs, and find the best option for your critical data.
The post Understanding Indexes in pgvector appeared first on Stormatics.
Seiten
- « erste Seite
- ‹ vorherige Seite
- …
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- …
- nächste Seite ›
- letzte Seite »