I did a talk on the similarities and differences between Oracle and PostgreSQL at CodeNode in London: https://skillsmatter.com/skillscasts/11414-london-postgresql-january#video
Have you ever restarted your PostgreSQL cluster and wondered why it’s taking so long? The cause of this is generally one of these: You didn’t include the “-m fast” flag (v9.4 and earlier), and sessions are still connected A large update query is rolling back There are a large number of dirty blocks, which are […]
For those of you that don’t monitor the pgsql-bugs mailing list, this interesting bug was posted recently: >> I have encountered a bug in PostgreSQL 10.1: when the target >> directory for pg_rewind contains a read-only file (e.g. server.key), >> pg_rewind exits with “could not open target file” (legitimate) and >> corrupts the control file […]
If you’re seeing an error like this in your postgresql.log: LOG: could not connect socket for statistics collector: Invalid argument LOG: disabling statistics collector for lack of working socket WARNING: autovacuum not started because of misconfiguration HINT: Enable the “track_counts” option. There’s a good chance that your localhost entry in /etc/hosts is broken. In my […]