Tag Archive for 'postgresql'

Dec3rd2007

PostgreSQL Re-Index, Index Corruption

Ever had a situation like this: Select from database ID where name = RICHARD; Returns and ID of 55 for example. Then go and do a query like this: Select * from some_other_table where ID = 55; Returns, “Sorry does not exist, time to die…..” Well apparently indexes when corrupt – which is NOT SUPPOSED […]

Nov18th2007

Drive Roaming. DELL PERC4 Controllers

During a recent test run to see if a new PostgreSQL back end server would hasten things up in a main cluster – that has now become CPU bound and NOT IO…… the wizardry of that I will blog about later. In any case, the short of it is, that we were juggling PERC4 cards […]

Sep3rd2007

The Verdict Is In!

Excellent Results! 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.

Sep1st2007

PostgreSQL Upgrade Part 3

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 […]

Sep1st2007

PostgreSQL Upgrade Part 2

Well, the PostgreSQL upgrade was a snap, sorta. I needed to do a full dump and restore as this was a major version change – no surprises there. What pissed me off though, is that when using the binary data type for dump files when using pg_dump (“-T c”) the resulting backup file is of […]

Sep1st2007

PostgreSQL Upgrade

Well this week was fun. For some reason one of our main clusters that runs client ASP software for general office, file, email, collaboration, etc… went crazy. First I noticed that the usual night time “Vacuum’s” that are needed to keep the PostgreSQL planar at it’s most efficient and indexes clean, was running right into […]