The Entity-Attribute-Value (EAV) data model is a design pattern to overcome the limitations of traditional relational databases. Its goal is to encode entities with a variable and a disparate number...
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...
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...
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...
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...
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...
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...
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...
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...
![Business Intelligence with Window Functions in PostgreSQL [Webinar]](/sites/default/files/styles/blog_image/public/blog_posts_images/Webinar-Youtube-Window-Function-in-PostgreSQL.png?h=8ad87400&itok=wC8rJRh8 "Business Intelligence with Window Functions in PostgreSQL [Webinar]")
![Postgres Vacuuming Through Pictures [Webinar]](/sites/default/files/styles/blog_image/public/blog_posts_images/Postgres-Vacuuming-Through-Pictures-Webinar.png?h=ce5fe46c&itok=TMeLBz3a "Postgres Vacuuming Through Pictures [Webinar]")