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

6 min read
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 ...

11 min read
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 ...

11 min read

More stories