PostgreSQL

Customizing PostgreSQL parameters in EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. In the last two posts we deployed an EDB database container and two pgpool instances and then(…)

Scaling the EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. When you followed the last post you should have two pgpool instances and one EDB Postgres instance running(…)

Deploying PostgreSQL in MiniShift/OpenShift

The last post quickly outlined on how you can setup MiniShift for playing around with OpenShift on your workstation. In this post we'll setup PostgreSQL in MiniShift using the default PostgreSQL image that already comes with MiniShift.

Setting up MiniShift

Currently we have many requests to support customers in running PostgreSQL in Docker containers. Some of those use redhat OpenShift as the management platform for their Docker deployments. Setting up an OpenShift cluster requires quite some resources and(…)

Can I do it with PostgreSQL? – 19 – Create user … identified by values

Puh, that last post in this series is already half a year old. Time is moving too fast :( Today, while being at a customer again, this question came up: Can I do something comparable in PostgreSQL(…)

2018.pgconf.de, recap

Finally I am home from pgconf.de in Berlin at the beautiful Müggelsee. Beside meeting core PostreSQL people such Devrim and Bruce, Andreas and joining Jan again for great(…)

Insert…on conflict with partitions finally works in PostgreSQL 11

Another partitioning improvement for PostgreSQL 11: Insert...on conflict is now supported (for most cases) in PostgreSQL 11 thanks to this commit. Lets see how it works.

The WAL segment size becomes changeable in PostgreSQL 11

Up to PostgreSQL 10 the wal segment size was fixed once PostgreSQL was compiled and installed. When you wanted to have something else than the default you needed to tell that to the configure command when building from source, e.g.

When you execute the same statement thousands of times -> prepare it

Every time you send a SQL statement to PostgreSQL it must be parsed. Parsing is fast, yes, but parsing the same statement a thousand times can quickly sum up to quite some time the database could spend for something else.

PostgreSQL – logical replication with pglogical

Although PostgreSQL 10 integrate native logical replication (have a look here or here), it is always interesting to be aware of alternative solutions to the available in-core features. One of those is called(…)