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 […]
Tag Archive for 'array'
Thought I should write something tech for a change! 😉 It is golden week here and all are away on break. So instead of forcing a staff member to come back, I thought I would take care of some stuff myself. My problems started when a client who has a large advertising cluster, was running […]
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 […]
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 […]
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 […]