Tag - PostgreSQL

Index Improvements in PostgreSQL 13

index improvements postgresql 13

Indexes are one of the core features of all the database management systems (DBMS). Indexes have a very long history in PostgreSQL, which has quite a rich set of index features. PostgreSQL has B-Tree, Hash,  GIN, GIST, and BRIN indexes. And because the development around indexes is still going on, PostgreSQL 13 provides some […]

Read more

Why PostgreSQL WAL Archival is Slow

PostgreSQL WAL Archival is Slow

It is very common to see many customer cases where a sudden increase in disk space usage is caused by a lot of WAL segments filling up the WAL directory (pg_wal). Panicking customers generally ask “Why isn’t PostgreSQL deleting them?”. The most common reasons we used to find were:

Failing WAL archival
A slot holding old […]

Read more

Webinar September 17: PostgreSQL High-Performance Tuning and Optimization

PostgreSQL High-Performance Tuning and Optimization

Please watch Percona’s Senior Software Engineer Ibrar Ahmed as he presents the “PostgreSQL High-Performance Tuning and Optimization” webinar.
PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with the least resources can run it. PostgreSQL does not give optimum […]

Read more

PostgreSQL synchronous_commit options and Synchronous Standby Replication

PostgreSQL synchronous_commit options and synchronous standby replication

I find myself discussing and explaining sychronous_commit with many PostgreSQL users, especially with novice users. So, I thought of noting down all the key points as a blog post which will be useful for more users. Recently I got an opportunity to talk about some related topics in our PostgreSQL Percona Tech Days.
What Is […]

Read more

Join Us For Percona Tech Days!

In the lead up to Percona Live Online, we are excited to introduce Percona Tech Days!
Percona Tech Days are free, half-day events dedicated to the most popular open source database technologies: MySQL, MongoDB, and PostgreSQL.
Each day, we’ll be focusing on one database technology, with expert presentations and conversations around technical topics, from the latest […]

Read more