There have been many big features added to PostgreSQL 13, like Parallel Vacuum, de-duplication of indexes, etc., and a complete list can be found at PostgreSQL 13 release notes. Along with the big features, there are also small ones added, including dropdb –force.
Dropdb –force
A new command-line option is added to dropdb command, and a […]
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.
How?
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