Learn how to effectively configure PostgreSQL log management for troubleshooting performance problems.
Window functions in PostgreSQL are a very useful tool; and since their introduction 10 years ago, they have been gradually adopted for various use cases where a simple aggregation is just not flexible enough — case in point, incremental totals and moving averages. The features introduced in PostgreSQL complete the implementation according to the SQL:2011 […]
Vacuum is one of the most important features for reclaiming deleted tuples in tables and indexes. Without vacuum, tables and indexes would continue to grow in size without bounds. This blog post describes the PARALLEL option for VACUUM command, which is newly introduced to PostgreSQL13. Vacuum Processing Phases Before discussing the new option in depth […]
Similarity queries are a popular requirement in many applications that need data integration, record linkage, data cleaning, data de-duplication, and fuzzy matching. PostgreSQL provides many features that allow you to run similarity queries. In order to explore this topic in detail, 2ndQuadrant arranged a live webinar, “Similarity Queries in PostgreSQL”, to dive into this topic […]
Vacuuming is a key feature of PostgreSQL databases to keep databases healthy and optimized. When enabled, autovacuum conserves space by removing obsolete disk usage and optimizes database performance by speeding up sequential scans, among many other benefits. As part of the ongoing PostgreSQL Webinar Series, 2ndQuadrant hosted a webinar on Postgres Vacuuming Through Pictures, which […]
PostgreSQL is a powerful database and supports multiple operating systems. Windows is a first-class example of PostgreSQL supported platforms. In order to explore this topic in detail, 2ndQuadrant arranged a live webinar, “PostgreSQL on Windows”. The session was hosted by Andrew Dunstan, Senior Developer & PostgreSQL Committer at 2ndQuadrant. The webinar covered the following topics: […]
PostgreSQL offers many advanced features that applications can use to store information reliably and efficiently for the longer term. One such feature is the ability to control transactions. In the third and final session, Gianni Ciolli, Head of Professional Services at 2ndQuadrant covered: Transactions and Locking: improve transaction flow by reducing contention. The Blind Spot […]
One of the interesting new features in PostgreSQL for some time now is the ability to control removal of WAL files using replication slots. The dark side is that replication slots can cause disks to fill up with old WAL, killing the main production server. In this article I explain PostgreSQL replication slots, and how a new feature in PostgreSQL 13 helps prevent this problem.
PostgreSQL offers many advanced features that applications can use to store information reliably and efficiently for the longer term. One such feature is the ability to control transactions. In the second session, Gianni Ciolli, Head of Professional Services at 2ndQuadrant covered: Replicated Transactions: replication can provide extra reliability, if properly used. Performance Expectations: will transactions […]
Unicode equivalence Unicode is a complicated beast. One of its numerous peculiar features is that different sequences of codepoints can be equal. This is not the case in legacy encodings. In LATIN1, for instance, the only thing that is equal to ‘a’ is ‘a’ and the only thing that is equal to ‘ä’ is ‘ä’. […]