Articles in postgresql 9.5

Cross-Database Querying in Compose PostgreSQL

In Compose PostgreSQL you can now perform cross-database queries using some extensions we've recently made available: postgres_fdw and dblink. In this article we'll walk through how to set up your database to take advantage of them. Both the postgres…

Continue reading »

Upgrading your PostgreSQL to 9.5

Upgrading your PostgreSQL deployment to version 9.5 is now possible through the Compose console. Working out how to perform this upgrade safely and reliably has been an interesting process because from version 9.4 to 9.5 is a PostgreSQL major upgrade…

Continue reading »

Compose Notes for PostgreSQL 9.5

PostgreSQL 9.5 is now on the Compose platform and we've got some notes about the new version of the database covering autoscaling and versions. Updating the PostgreSQL Autoscaling Algorithm With the arrival of PostgreSQL 9.5, we're updating how we de…

Continue reading »

Deeper into Postgres 9.5 - New Group By Options for Aggregation

If you use PostgreSQL, you'll know that its relational model and aggregate functions lend themselves easily to the creation of business reports. In 9.5, aggregating data for reports is made more powerful by the addition of some new GROUP BY options:…

Continue reading »

PostgreSQL 9.5 now on Compose

PostgreSQL 9.5 is now available with Compose. To be precise, PostgreSQL 9.5.2, the very latest release is now available on Compose. We've been tracking PostgreSQL 9.5's development since last May, testing out upsert and many more of its new feature…

Continue reading »