A quick pg_stat_statements troubleshooting hack
How can pg_stat_statements be used for troubleshooting? Some tips to access all relevant information without using monitoring tools.
What is fillfactor and how does it affect PostgreSQL performance?
In this blog posting you find out: What is fillfactor and how does it affect PostgreSQL performance? | Effects & Testing
PostgreSQL: More performance for LIKE and ILIKE statements
This blogpost shows what PostgreSQL can do to speed up LIKE and ILIKE to archieve better PostgreSQL database performance.
Join strategies and performance in PostgreSQL
by
Laurenz Albe |
06.2020 (Updated 2023-02-24) There are three join strategies in PostgreSQL that work quite differently. If PostgreSQL chooses the wrong strategy, […]
Composite type performance issues in PostgreSQL
Table functions & performance: Solve performance issues related to stored procedures and or a composite data type in PostgreSQL
Deduplication in PostgreSQL v13 B-tree indexes
by
Laurenz Albe |
06.2020 A while ago, I wrote about B-tree improvements in v12. PostgreSQL v13, which will come out later this year, […]
PostgreSQL: Speeding up recursive queries and hierarchical data
How to use a hierarchical query, which is an SQL query that handles model data such as the structure of organizations - find out more
Binary data performance in PostgreSQL
by
Laurenz Albe |
05.2020 A frequently asked question in this big data world is whether it is better to store binary data inside […]
PostgreSQL: Network latency does make a BIG difference
Find out about how network latency is essential to PostgreSQL database performance. Measure the performance impact caused by latency.
7 things that could be improved in PostgreSQL
UPDATE July 2023: What could be better in PostgreSQL? Find out about its weak points, and see what has improved since 2020.
