~postgresweekly | Bookmarks (4)

journald and Syslog Logging in Postgres — Using journald and syslog logging with Postgres isn’t a new idea, but Laurenz thinks more people should be giving it a go and so has put together this basic tutorial: “I switched my PostgreSQL instance to syslog logging, and I don’t think I will switch back.”

Recovering Deleted Data from Postgres Tables — Transactions and backups cover most situations, but can you do something similar to an ‘undelete’ on data otherwise considered deleted from a table? With pg_dirtyread, you can do quite a bit and, failing that, you could even go digging into the WAL..

Enforcing Join Orders in Postgres — With SQL being a declarative language, you'd reasonably expect Postgres to handle the complexities of joining tables in the way you require. It usually does a good job, but there are sometimes reasons to force Postgres to take a different approach..

Optimizing Postgres Functions with Preloaded Libraries — Thanks to extensions, it’s possible to write Postgres functions in numerous different languages, but those extensions need to be loaded when needed – the session_preload_library can be used to preload libraries at connection start, shaving off precious milliseconds.