PostgreSQL

Auto pre-warming in EDB Postgres Advanced Server 10

Some days ago EDB Postgres Advanced Server 10 was released and one feature which might be handy is auto pre-warming. What this does is to save all the buffers (or better a description of the buffers) which(…)

Displaying the contents of a PostgreSQL data file with pg_filedump

Did you ever wonder what exactly is in a PostgreSQL data file? Usually you don't care, I agree. But there might be situations where knowing how you can do this might be a great help. Maybe your file is corrupted(…)

Can I have the same table published and subscribed (bi-directional) in PostgreSQL 10 logical replication?

When you start using PostgreSQL 10 logical replication you might think it is a good idea to setup bi-directional replication so you end up with two or more masters that are all writable. I will not go into the details(…)

Are large objects supported in PostgreSQL 10 logical replication?

Another interesting topic that popped up last week during pgconfeu: Are large objects supported with logical replication in PostgreSQL 10? The only truth is a test, isn't it? Lets go...

Dbvisit replicate – SQL Developer chart

By Franck Pachot . Here is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours(…)

Are temporary tables auto vacuumed in PostgreSQL?

While doing the EDB quiz at their booth last week at pgconfeu one of the questions was: Are temporary tables auto vacuumed? What do you think? My first thought was yes, but lets see. The first question(…)

PostgreSQL Index Suggestion With Powa

By Mouhamadou Diaw A few time ago my colleague Daniel did a blog about POWA. In a nice article he shown how this tool can be used to monitor our PostgreSQL. In this present(…)

And finally it is there…PostgreSQL 10

What are you waiting for?(…)

Announcing the dbi OpenDB Appliance

As already announced on Twitter and LinkedIn here is the blog post to describe our OpenDB appliance in more detail. I am sure you wonder what this is about so let me explain why we are(…)

Searching wikipedia from the command line

Wouldn't it be nice if you could search wikipedia from the command line? I often need to quickly look up a definition or want to know more about a specific topic when I am working on the command(…)