Postgres is an incredibly powerful database that’s packed with many different features. Some of its most interesting and productive capabilities,...
Blog Posts by
Blog Posts by Bruce Momjian
Is the Oracle-DBA Relationship Breaking Down? The world of the Database Administrator (DBA) has changed since the technology went mainstream in the...
Tablespaces are designed to allow Postgres clusters to be spread across multiple storage devices. Create tablespace creates a symbolic link in the...
Usually, the database administrator controls who can access database data. However, it is possible for clients to completely control who can access...
When storing data in the database, there is an assumption that you have to trust the database administrator to not modify data in the database. While...
I’ve come to the end of my time in Europe now and I thought I’d share some of the feedback I’ve received from EDB customers along the way. I’ve been...
I have been in Europe now for more than two weeks meeting a number of our customers and PostgreSQL users at the EDB Postgres Summer School. So far I...
I previously mentioned the importance of high quality documentation, so we are always looking for improvements. This email thread from 2013 attempted...
Postgres isn't the best at naming things. Of course, there is the old computer saying, "There are only two hard things in Computer Science: cache...
*/ An age-old question is whether it is better to put data in a database or a file system. Of course, the answer is "it depends," but let's look at...
Postgres Alerts It is cool to be able to stare at colorful graphs to see what Postgres is doing, but sometimes you just want to setup something, walk...
During research for my Postgres Window Magic talk, I studied the unusual behavior of percent_rank and cumm_dist ( cumulative distribution ). The...
In a previous blog entry I suggested storing the original time zone offset in a separate column if clients need to know the stored time in the...
*/ You might know that Postgres supports materialized views and foreign data wrappers (fdw). Briefly, materialized views allow for queries to be...
On the server side, high availability means having the ability to quickly failover to standby hardware, hopefully with no data loss. Failover...
Now that everyone is using IPv6 ( ) it might be time to start playing with it. Postgres has had full IPv6 support for years, so Postgres is a good...
