PostgreSQL

PostgreSQL on a Pure Storage All Flash Array – Populating PostgreSQL

Just be clear this is not a performance test as we had to connect the Pure Storage box through 1GB/s interfaces. Basically it is more about how you can interact with the storage system (command line & web interface) and(…)

Testing new PostgreSQL features before alpha/beta/rc releases

A long time ago I blogged on how you can use the PostgreSQL development snapshots to test new PostgreSQL features before alpha/beta/rc releases are officially released. Another way to do this is to use(…)

PostgreSQL on a Pure Storage All Flash Array – Preparations

Yesterday we got a Pure Storage All Flash Array for testing. As the name implies this is all about Flash storage. What makes Pure Storage different from other vendors is that you don't buy just a storage(…)

Save the date: Swiss PGDay 2017

The 30th of June is not too far away and if you want to learn more about the “World’s most advanced open source database” you should register soon. The sessions are not yet officially announced but(…)

Does the wal segment size matter in PostgreSQL?

In PostgreSQL you configure the size of the wal (write ahead log) segments when you compile from source. If you use an installer or if you use the packages provided by your OS distribution the size of the(…)

Listing the extensions available in PostgreSQL

When you follow this blog regularly you probably already now that PostgreSQL is highly extensible. There are quite a couple of extension which ship by default and are ready to use. How can you know what is(…)

In-core logical replication will hit PostgreSQL 10

Finally in PostgreSQL 10 (expected to be released this September) a long awaited feature will probably appear: In-core logical replication. PostgreSQL supports physical replication since version 9.0 and now the next step happened with the implementation of logical replication. This(…)

PostgreSQL 10 is just around the corner, time to dare the switch?

Some days ago Robert Haas published a great blog post about the features you can expect for the upcoming PostgreSQL 10 (probably in September this year). Beside of what Robert is describing in his blog: Do you(…)

Can I do it with PostgreSQL? – 14 – optimizer hints

This is a question that comes up quite often: How can I use optimizer hints in PostgreSQL as I can do it in Oracle? Well, you cant, and the reasons are this: Poor(…)

Can I do it with PostgreSQL? – 12 – dbca (database configuration assistant)

Short answer: No. Long answer: No. Every other possible answer: No. There is no such tool in PostgreSQL. In Oracle you can use the database configuration assistant to create your Oracle database. But this is not a must,(…)