planet.postgresql.org planet.postgresql.org

Dave Page: system_stats extension for PostgreSQL

One of my colleagues at EDB spent some time working on a new extension for PostgreSQL and EDB Postgres Advanced Server as part of a proof of concept that I asked him to look into. I'm pleased to say that we've decided to make that work Open Source, releasing it under the PostgreSQL licence.The system_stats extension offers a number of stored procedures that are useful when monitoring Postgres. They expose various system metrics to...

planet.postgresql.org planet.postgresql.org

Achilleas Mantzios: PostgreSQL Anonymization On Demand

Before, during, and after the GDPR came into town in 2018, there have been many ideas to solve the problem of deleting or hiding user data, using various layers of the software stack but also using various approaches (hard deletion, soft deletion, anonymization). Anonymization has been one of them which is known to be popular among the PostgreSQL-based organizations/companies. In the spirit of GDPR, we see more and more the requirement...

planet.postgresql.org planet.postgresql.org

Douglas Hunley: tuned, PG, and you

We’ve had a small flurry of customers asking about tuning their OS for the best PostgreSQL performance. While the answer to this question is always ‘that depends on your hardware and workload’ and involves a lot of iteration between changing a setting and benchmarking, I thought I’d take a moment to point out that once you do manage to dial-in the settings, you should be writing a profile and deploying to your systems for tuned...

planet.postgresql.org planet.postgresql.org

Hans-Juergen Schoenig: PostgreSQL: ltree vs. WITH RECURSIVE

After my last post about ltree and recursive data in PostgreSQL people have asked me privately about performance issues. To share this information, I decided to come up with a follow up post to discuss this topic in a bit more detail. WITH RECURSIVE in PostgreSQL is efficient. However, ltree does have its strengths as well. Let us take a closer look … Preparing sample data In preparation for a test I have created a table which...