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
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 […]
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 […]
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 […]
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 […]