Database Administration & Monitoring, Database management 2024.pgconf.eu – Bigger than ever, the family is growing fast 26.10.2024 by Daniel Westermann The PostgreSQL community is growing every year and the same happens for pgconf.eu, which happened in Athens, Greece, this year. Attending this event is one of the best opportunities to get in touch with the people behind PostgreSQL. This year(…)
Database Administration & Monitoring, Database management Improved not null/null planning in PostgreSQL 17 18.10.2024 by Daniel Westermann PostgreSQL 17 came with quite some additional features for the optimizer. One of them is about “is null” and “is not null” handling when column have a “not null” constraint defined. In the past it was(…)
Database Administration & Monitoring, Database management PostgreSQL 18: Tweaking relation statistics 15.10.2024 by Daniel Westermann Up to now, there is no official way in PostgreSQL to tweak optimizer statistics manually. While this is quite common in other relational databases, PostgreSQL did not provide anything to do this. The first steps to allow this have now(…)
Database Administration & Monitoring, Database management PostgreSQL 18: REJECT_LIMIT for COPY 11.10.2024 by Daniel Westermann With the just released version of 17 of PostgreSQL, copy got the “ON_ERROR” switch. This is very useful if you load something which contains rows that cannot be inserted into the target(…)
Database Administration & Monitoring PostgreSQL 18: Verify tar format and compressed backups 30.09.2024 by Daniel Westermann While PostgreSQL 17 was released just a couple of days ago, the development of PostgreSQL 18 is already going on and the first patches got committed. One of them addresses a limitation with pg_verifybackup: Currently(…)
Database Administration & Monitoring PostgreSQL: Partitioned tables and optimizer statistics 25.09.2024 by Daniel Westermann The PostgreSQL optimizer relies on accurate statistics for finding and executing the most efficient plan for a given statement. Wrong or bad statistics usually lead to sub optimal execution plans and this usually is bad performance wise. This is not(…)
Database Administration & Monitoring PostgreSQL: pg_dump and extension ownership 23.09.2024 by Daniel Westermann While pg_dump must not be considered a backup tool (please use physical backups for this), it is widely used to dump and reload data. One of the main advantages is, that you can do this across major versions of(…)
Cloud, Database Administration & Monitoring, Database management, DevOps CloudNativePG – Connecting external applications 16.08.2024 by Daniel Westermann Now that we know how we can benchmark a CloudNativePG deployment, it is time to look at how we can connect external applications to the PostgreSQL cluster. Usually, applications run in the same Kubernetes cluster and(…)
Cloud, Database Administration & Monitoring, Database management, DevOps CloudNativePG – Benchmarking 15.07.2024 by Daniel Westermann Now that we’ve configured our storage in the last post, it is time to benchmark the system. One popular tool when it comes to benchmarking PostgreSQL is pgbench. This can be used(…)
Cloud, Database Administration & Monitoring, Database management, DevOps CloudNativePG – Storage 05.07.2024 by Daniel Westermann This is the next post in the series about CloudNativePG (the previous one are here, here, here, here, here and(…)