Neues vom PostgreSQL Planet
PostgreSQL database writes all changes happening in the database to a log file before it writes them to the actual data files. These log files are called WAL (Write-Ahead Log). Until these changes are flushed to the disk, they are kept in memory and is returned from the memory when it’s asked for. Writing to the data files directly is a costly operation for several reasons and is performed periodically.
Hubert 'depesz' Lubaczewski: How to install and configure PostgreSQL Debian/Ubuntu – for developer use – part 2
While developing SQL based applications, it is commonplace to stumble on these 2 questions:
- What DDLs would block concurrent workload?
- Whether a DDL is going to rewrite the table (and in some cases may need ~ 2x disk space)?
Although completely answering Question 1 is beyond the scope of this post, one of the important pieces that helps answering both of these questions is whether a DDL is going to cause a relfilenode change..
Continue reading "RPM repository for unsupported PostgreSQL releases / distros"
Continue reading "What is new in PostgreSQL 13 RPMs?"