PostgreSQL: Improving sort performance

Sorting is a very important aspect of PostgreSQL performance tuning. However, tuning sorts is often misunderstood or simply overlooked by many people. So I decided to come up with a PostgreSQL blog showing, how sorts can be tuned in PostgreSQL. Creating sample data To show how sorting works, I created a couple of million rows […]

Read more

PostgreSQL clusters: Monitoring performance

When people are talking about database performance monitoring, they usually think of inspecting one PostgreSQL database server at a time. While this is certainly useful, it can also be quite beneficial to inspect the status of an entire database cluster or to inspect a set of servers working together at once. Fortunately, there are easy […]

Read more

PostgreSQL performance tuning

Our PostgreSQL consultants can advise you on how to optimize your database and make overall improvements in your database performance. If you are looking for PostgreSQL performance tuning because you want a fast, reliable database that simply works, we are here to help. Tuning PostgreSQL memory parameters Are you wondering which values to put into […]

Read more

Better PostgreSQL performance on SSDs

The optimizer uses several parameters to optimize queries. Those parameters have been constant for many years in the past. This was fine for most users. Recently we have seen a couple of systems which were already fully based on SSD disks. SSDs have a nice advantage over traditional disks: Random disk access is not a […]

Read more