Key takeaways: Indexes should reduce the amount of read data blocks necessary to answer a query Execution plan of a query depends on the data… Read More »Index efficiency and maintenance – PostgreSQL 12 High Performance Guide (Part 5/12)

Key takeaways: Any time you UPDATE or DELETE, you will leave a dead row behind (and potentially a dead index entry) that needs to be… Read More »Configuring Vacuum for Performance – PostgreSQL 12 High Performance Guide (Part 4/12)

Key takeaways Opening a new PostgreSQL connection is a fairly expensive operation in terms of CPU used. Connection poolers keep some of those connections open… Read More »Connection pooling – PostgreSQL High Performance Guide (Part 3/12)

Key takeaways PostgreSQL allocation for the default shared_buffers is extremely low and we need to increase it to allow proper shared memory size for the… Read More »Optimizing PostgreSQL shared_buffers – PostgreSQL High Performance Guide (Part 2/12)

Key takeaways PostgreSQL is often shipped with a configuration that isn’t suitable for production. Due to this, you should at least configure the PostgreSQL buffer… Read More »PostgreSQL Architecture – PostgreSQL High Performance Guide (Part 1/12)