Database Administration & Monitoring, Database management 2023.pgconf.eu – recap 19.12.2023 by Daniel Westermann This year’s edition of PostgreSQL Conference Europe finished last Friday, the 15th of December. It was the largest ever PostgreSQL Conference Europe with more than 700 attendees. For me the week already started on Monday, because(…)
Database Administration & Monitoring, Database management PostgreSQL 17: Reset shared statistics at once with pg_stat_reset_shared() 12.11.2023 by Daniel Westermann PostgreSQL comes with several catalog views which expose cluster wide statistics. One of them is the new pg_stats_checkpointer view we’ve talked about previously. To reset some of those statistics there is pg_stat_reset_shared().
Database Administration & Monitoring, Database management PostgreSQL 17: New catalog view pg_stat_checkpointer 06.11.2023 by Daniel Westermann Up to PostgreSQL 16 checkpointer related statistics are available in pg_stat_bgwriter. As the work of bgwriter and checkpointer has been split into two separate processes back in 2011 for PostgreSQL 9.2 (see 806a2aee3791), it makes sense(…)
Database Administration & Monitoring, Database management DBVISIT StandbyMP for PostgreSQL – 3 – Switchovers 06.11.2023 by Daniel Westermann In the last two posts (here and here) we’ve installed and configured DBVISIT StandbyMP for PostgreSQL and created a simple primary -> replica setup. Most of the replication(…)
Database Administration & Monitoring, Database management What is the maximum number of columns for a table in PostgreSQL? 05.11.2023 by Daniel Westermann In our PostgreSQL DBA Essentials workshop we’re also letting the attendees know about the limits of PostgreSQL. Those limits are documented but one of those limits might not be very clear. The(…)
Database Administration & Monitoring, Database management DBVISIT StandbyMP for PostgreSQL – 2 – Creating a PostgreSQL configuration 30.10.2023 by Daniel Westermann In the previous post we’ve installed the DBVISIT StandbyMP agents on the database nodes, and the management console on third node. In this post we’re going to create our first PostgreSQL configuration.
Database Administration & Monitoring, Database management DBVISIT StandbyMP for PostgreSQL – 1 – Setting it up 27.10.2023 by Daniel Westermann One of our oldest partners, DBVISIT, recently released their product StandbyMP for PostgreSQL. The goal of this product is to provide a graphical user and management interface over a PostgreSQL streaming replication(…)
Database Administration & Monitoring, Database management Locales, collations, encodings and the PostgreSQL sort order (2) – sorting strings 25.10.2023 by Daniel Westermann In the last post we’ve looked at how you can tell initdb which character set and locale it should use for the initial databases. In this post we’ll look at how you(…)
Database Administration & Monitoring, Database management Locales, collations, encodings and the PostgreSQL sort order (1) – basics 20.10.2023 by Daniel Westermann When it comes to sorting strings it is all about locales and how PostgreSQL is using them. PostgreSQL uses the locales provided by the underlying operating system, by default this is “C” or “POSIX”. To see(…)
Database Administration & Monitoring, Database management What is the difference between session_user and current_user in PostgreSQL? 19.10.2023 by Daniel Westermann When you want to know the currently connected user in PostgreSQL for your session there are two system information functions which seem to do the same thing. There is “session_user” and there is “current_user”. So what is the difference between(…)