Month: February 2014
Adjusting maintenance_work_mem
After testing shared_buffers recently, I decided to do a little more testing on our new office desktop PC (8 core AMD CPU, 4 GHZ, 8 GB RAM and a nice 128 GB Samsung 840 SSD). All tests were conducted on the SSD drive. This time I tested the impact of maintenance_work_mem on indexing speed. To get […]
Read more
PostgreSQL 9.3 – Shared Buffers Performance (1)
A lot has been said about PostgreSQL shared buffers and performance. As my new desktop box has arrived this week I decided to give it a try and see, how a simple benchmark performs, given various settings of shared_buffers. The first thing to run the test is to come up with a simple test database. […]
Read more