PostgreSQL 13 is released with some cool features, such as index enhancement, partition enhancements, and many others. Along with these enhancements, there are some security-related enhancements that require some explanation. There are two major ones: one is related to libpq and the other is related to postgres_fdw. As it is known that postgres_fdw is […]Read more
So you’ve installed postgres onto your machine, and you want to start working with it.
The key to understanding the post-installation procedure is to realize that it “depends”.
It “depends” on the OS i.e. MSWindows vs Linux.
It “depends” on the flavor of Linux i.e. Debian vs RedHat.
It “depends” if it’s a package install or from source […]
I have previously written a blog post on the detailed steps involved in enabling PostgreSQL monitoring using PMM. In that post, you could see me talking about the role: pg_monitor that can be granted to monitoring users. The
pg_monitor role restricts a monitoring user from accessing user data but only grants access to statistic […]
Indexes are one of the core features of all the database management systems (DBMS). Indexes have a very long history in PostgreSQL, which has quite a rich set of index features. PostgreSQL has B-Tree, Hash, GIN, GIST, and BRIN indexes. And because the development around indexes is still going on, PostgreSQL 13 provides some […]Read more
It is very common to see many customer cases where a sudden increase in disk space usage is caused by a lot of WAL segments filling up the WAL directory (pg_wal). Panicking customers generally ask “Why isn’t PostgreSQL deleting them?”. The most common reasons we used to find were:
Failing WAL archival
A slot holding old […]