Let me discuss a topic that is not inherently PostgreSQL specific, but that I regularly run into while investigating issues on customer systems, evaluating “supportability” of those systems, etc. It’s the importance of having a monitoring solution for system metrics, configuring it reasonably, and why sar is still by far my favorite tool (at least […]
Up to date access to postgres logs
/2 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanSome of my Italian colleagues have made a nifty little gadget called redislog for pushing postgres logs into Redis, the distributed in-memory cache. From there it can be fed into things like logstash. I thought it would be interesting instead to make the logs available via the Redis Foreign Data Wrapper as a Postgres table. […]
Logical Replication in PostgreSQL 10
/37 Comments/in Petr's PlanetPostgreSQL /by Petr JelinekPostgreSQL 10 is getting close to its first beta release and it will include the initial support for logical replication, which is was written primarily by me and committed by my colleague Peter Eisentraut, and is internally based on the work 2ndQuadrant did on pglogical (even though the user interface is somewhat different). I’d like […]
Out of tree builds
/3 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanRecently I was asked “what’s a vpath build?” If you regularly build postgres from source it’s something you should know about. A vpath build is one where the build tree is kept completely separate from the source tree, so you can completely remove the build tree and your source tree is still there, clean and […]
In the defense of sar (and how to configure it)
/6 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraLet me discuss a topic that is not inherently PostgreSQL specific, but that I regularly run into while investigating issues on customer systems, evaluating “supportability” of those systems, etc. It’s the importance of having a monitoring solution for system metrics, configuring it reasonably, and why sar is still by far my favorite tool (at least […]
PostgreSQL 10 identity columns explained
/27 Comments/in Eisentraut's PlanetPostgreSQL, PostgreSQL /by Peter Eisentraut“Now is Better Than Never” – Why I decided to attend PyCon8…
/0 Comments/in 2ndQuadrant, Britt's PlanetPostgreSQL /by Britt Cole…and why I’m glad I did. It’s not all technical… Who knew?! Last year, Pycon7 was held right about the time I joined 2ndQuadrant. Seeing as I was new to the technology AND the Italian language (note: there was an English track), I opted out of attending. Well, after attending Pycon8, I can say that […]
BuildFarm client release 4.19
/0 Comments/in Andrew's PlanetPostgreSQL /by Andrew DunstanI have released version 4.19 of the PostgreSQL Buildfarm client. It can be downloaded from http://buildfarm.postgresql.org/downloads/releases/build-farm-4_19.tgz Apart from some minor bug fixes, the following changes are made: Include the script’s path in @INC. That means you can usually run the script from anywhere rather than just its own directory. Set TZ after “make check” is […]
When autovacuum does not vacuum
/9 Comments/in 2ndQuadrant, PostgreSQL, Tomas' PlanetPostgreSQL /by Tomas VondraA few weeks ago I explained basics of autovacuum tuning. At the end of that post I promised to look into problems with vacuuming soon. Well, it took a bit longer than I planned, but here we go. To quickly recap, autovacuum is a background process cleaning up dead rows, e.g. old deleted row versions. […]
Using the PostgreSQL TAP framework in extensions
/3 Comments/in Craig's PlanetPostgreSQL /by craig.ringerSupport for using the TAP protocol to run extended regression tests was added to PostgreSQL back in 9.4 with the adoption of Perl’s prove tool and Test::More to test initdb, pg_basebackup, etc. Since then the TAP-based tests have been greatly expanded, particularly with the advent of the src/test/recovery tests and the PostgresNode module in PostgreSQL […]
Traceable commit for PostgreSQL 10
/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringerPostgreSQL 10 now supports finding out the status of a recent transaction for recovery after network connection loss or crash.