BE SHARING

Daniel Westermann

PostgreSQL 16: More I/O statistics

14.02.2023 by Daniel Westermann

PostgreSQL is already tracking various kinds of statistics which can help in identifying bottlenecks. Some of these statistics are available in the the pg_statio_* catalog views: postgres=# select viewname from pg_views where viewname like '%statio%'; viewname -------------------------- pg_statio_all_sequences pg_statio_all_tables pg_statio_sys_tables(…)

Database Administration & Monitoring

PostgreSQL 16: reserved_connections

22.01.2023 by Daniel Westermann

The maximum number of connections that PostgreSQL will allow, is controlled by the max_connections parameter. By default this allows a maximum of one hundred connections: postgres=# show max_connections; max_connections ----------------- 100 (1 row) In reality not one hundred connections(…)

Database Administration & Monitoring

Converting from Unix timestamps to “real” timestamps in PostgreSQL

13.01.2023 by Daniel Westermann

Recently we’ve been asked how an application can be changed from using Unix timestamps to PostgreSQL timestamps. It is still not so uncommon to store dates and times in numeric data types,(…)

Operating systems

The adaptable Linux Platform (ALP)

05.01.2023 by Daniel Westermann

This is about something you maybe didn’t hear much yet: The openSUSE project and SUSE are working on a new enterprise operating system: ALP, the adaptive Linux Platform.

Database Administration & Monitoring

Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (2) – Adding a client

29.12.2022 by Daniel Westermann

In the last post we’ve installed and configured the Uyuni server. In this post we’ll add our first client we later on can manage through the Uyuni server. Quite some distributions are(…)

Database Administration & Monitoring

Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (1) – The server

28.12.2022 by Daniel Westermann

Most of you probably heard of Red Hat Satellite, a product which is used to manage Linux infrastructures. Maybe you also heard about SUSE Manager, which does more or less the same(…)

Database Administration & Monitoring

PostgreSQL 16: Further reducing tasks that require superuser

14.12.2022 by Daniel Westermann

In a previous post we’ve seen that vacuum and analyze operations can be granted to users which are not superuser starting with PostgreSQL 16. Work is still in(…)

Database Administration & Monitoring

New cast testing functions for PostgreSQL 16

13.12.2022 by Daniel Westermann

As the development of PostgreSQL moves on, more and more new features get committed. A recently commit patch added two new functions, which can be used to validate if a cast will work and what error message would be returned(…)

Database Administration & Monitoring

Improve your development experience in PostgreSQL’s PL/pgSQL by using plpgsql_check

09.12.2022 by Daniel Westermann

In the last post we’ve highlighted some tips when developing functions and/or procedures in PostgreSQL’s PL/pgSQL. Especially the Compile-Time and Run-Time checks can save you a lot of work and give you important hints while developing(…)

Database Administration & Monitoring

Some tips when developing in PostgreSQL’s PL/pgSQL

06.12.2022 by Daniel Westermann

When you develop functions or procedures in PostgreSQL’s PL/pgSQL there are some points to consider, which make your life easier. This post is not about control structures, nor(…)