Why are my PostgreSQL updates getting slower?
by
Laurenz Albe |
10.2022 Recently, a customer asked me why a bulk load into a PostgreSQL table kept slowing down as time went […]
Find and fix a missing PostgreSQL Index
Explains how to find a missing Postgresql index, what you can do to fix missing indexes, and how to achieve good database performance.
PostgreSQL vs Redis vs Memcached performance
PostgreSQL vs Redis vs Memcached: How would it look on the performance side, if one just skips the cache & hits the database directly?
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.
Tuning max_connections in PostgreSQL
by
Laurenz Albe |
04.2020 (Updated 2023-02-22) In my daily work, I see many databases with a bad setting for max_connections. There is little […]
Improving transaction latency by moving indexes to faster media
To improve PostgreSQL transaction latency for OLTP systems a good trick is to move indexes of busy tables to fast SSD media.
Avoiding unnecessary function calls in PostgreSQL
Fix bad performance related to slow function calls: When it comes to slow procedures, PostgreSQL often isn't to blame. Here's why.
PostgreSQL: Speeding up GROUP BY and joins
Most people actually implement aggregations slightly wrong in PostgreSQL. This blogpost shows how to spped up group by and joins.
Composite types in PostgreSQL: (func()).* - Hidden performance issues
Using composite types offers db developers a great deal of flexibility. Passing complex data to functions is a lot easier.
pgstrom: Checking GPU performance
A more extensive look at pgstrom (a module to make use of GPUs for PostgreSQL). I was excited to see the first real performance data.
