Posts Tagged ‘postgresql’

The Verdict Is In!

Monday, September 3rd, 2007

Excellent Results!

CPU

CPU

System load was DOWN. This is due to much better disk IO (reduced wait times) and as such, user processes get to breath and send stuff back to clients in a speedy fashion.

(more…)

PostgreSQL Upgrade Part 3

Saturday, September 1st, 2007

I knew the config files were different between 7.4 and 8.1 and that some items merely changed names and some were deprecated.

I used this excellent resource before.

Even the very rudimentary tweaks I did, and with a RAID array that is in a 90% rebuild rate, background initialisation, this 8.1 version is FAST! I have no idea why people use MySQL, it really is such a piece of crud.