You are reading a single comment by @Velocio and its replies.
Click here to read the full conversation.
-
An older version than that.
I really need to spend time dragging it up a few versions. In my mind I've kinda thought I'll wait until 10 is released as stable, but I should've been updating it before now.
We're on PostgreSQL 9.2 stable.
Velocio-
I feel your pain, we have a few (big,replicated) legacy systems on 9.2 that need upgrading. pg_upgrade helps (and is quick if using hard links), but only for the master - slaves still need data to be rsync'ed.
PG10 does look very cool, logical replication and better control over the planner especially.
danb
What postgres version are you running? I have seen some big improvements in query planning and overall performance with 9.6