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...

Idle Transactions Cause Table Bloat? Wait, What?

What Is Table Bloat?Table bloat in PostgreSQL occurs when unused or outdated data, known as dead tuples, accumulates in tables and indexes. PostgreSQL uses aMulti-Version Concurrency Control (MVCC)mec...