Recent stories
One of the hidden mechanics of PostgreSQL may not seem important at first

One of the hidden mechanics of PostgreSQL may not seem important at first
When you INSERT a row into some databases like Oracle, the row is only written to the datafile, once the row has been ...
What is the Best Way to Shrink Your Tables in PostgreSQL?

What is the Best Way to Shrink Your Tables in PostgreSQL?
In PostgreSQL (PG), there are two issues when it comes to table bloat. One is a consequence of the MVCC (Multi-Version ...
Solving PostgreSQL's pg_basebackup 'ERROR: temporary file size exceeds temp_file_limit (1KB)'

Solving PostgreSQL's pg_basebackup 'ERROR: temporary file size exceeds temp_file_limit (1KB)'
When performing a pg_basebackup in PostgreSQL, you might run into this frustrating error: pg_basebackup: error: could ...