Tag - PostgreSQL

PostgreSQL WAL Retention and Clean Up: pg_archivecleanup

WAL retention is a very important topic for PostgreSQL database management. But very often we come across DBAs getting into surprise situations such as:
1. Several TBs of WALs piled up in archive destination
2. WALs filling up pg_wal/pg_xlog directory due to failing archive
3. Necessary WALs are no longer preserved
External backup projects for PostgreSQL are good […]

Read more

Installing and Configuring JIT in PostgreSQL 11

JIT with PostgreSQL

Just-in-time (JIT in PostgreSQL) compilation of SQL statements is one of the highlighted features in PostgreSQL 11. There is great excitement in the community because of the many claims of up to a 30% jump in performance. Not all queries and workloads get the benefit of JIT compilation. So you may want to test your workload against this […]

Read more

Track PostgreSQL Row Changes Using Public/Private Key Signing

PostgreSQL encryption and authorization

Authorisations and encryption/decryption within a database system establish the basic guidelines in protecting your database by guarding against malicious structural or data changes.
What are authorisations?
Authorisations are the access privileges that mainly control what a user can and cannot do on the database server for one or more databases. So consider this to be like […]

Read more

Tuning PostgreSQL Database Parameters to Optimize Performance

Tuning PostgreSQL Database Parameters

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. Default values are set to ensure that PostgreSQL runs everywhere, with the least resources it can consume and so that it doesn’t cause any vulnerabilities. It has default settings for all of the database parameters. It is primarily the […]

Read more

Tune Linux Kernel Parameters For PostgreSQL Optimization

linux kernel parameters

For optimum performance, a PostgreSQL database depends on the operating system parameters being defined correctly. Poorly configured OS kernel parameters can cause degradation in database server performance. Therefore, it is imperative that these parameters are configured according to the database server and its workload. In this post, we will discuss some important Linux kernel […]

Read more