What Hurts in PostgreSQL Part One: Temporary Tables

PostgreSQL is one of the most powerful database systems in the world. I have always been passionate about its great power, especially its modern SQL language features.However, that doesn’t mean every...

pg_squeeze 1.8: Extension to Automate Table Bloat Cleanup

PostgreSQL extension that removes unused space from a table and optionally sorts tuples according to particular index (as ifCLUSTERcommand was executed concurrently with regular reads / writes). In fa...

commit_delay for better performance: a PostgreSQL benchmark

The transactional workload synchronous_commit can be tuned by disabling the parameter. this measure has amazing results. But the possibility of losing committed transactions during an operating system...

Replacing Oracle Hints: Best Practices with pg_hint_plan on PostgreSQL

If you're migrating from Oracle Database to PostgreSQL, you're likely accustomed to using hints to optimize queries. In Oracle, these are special directives embedded in SQL(like /*+ INDEX(...) */) that steer the optimizer's execution plan. They can be extremely useful but also introduce complexity and “hint debt” over time.

A New Postgres Block Storage Layout for Full Text Search

We recently completed one of our biggest engineering bets to date: migratingpg_search, a Postgres extension for full text search and analytics, to Postgres' block storage system. In doing so,pg_se...

pgwatch 3.0: A Flexible Postgres Monitoring Solution

pgwatchis a flexible PostgreSQL-specific monitoring solution, offering a comprehensive view of database performance and health. It provides a user-friendly interface through Grafana dashboards, allowi...