My personal experience with RAID cards is that you have to spend money to get good
performance. You need battery backed cache because RAID 5 only works well with write
to cache turned on, and you need a good size cache too. If you don't have it, RAID 5
performance will suck big time. If you n
In the performance case the machine was running RedHat AS 2.1. I have posted the
database schema at (obtained from pg_dump -s):
http://serverbeach.plexq.com/~aturner/schema.sql
The time to run all the stats procedures dropped through the floor.
refresh_hourly_iud, adl_hourly_iud
Thanks for the URL, I went through postgresql.conf and made some modifications to the
config based on information therein. I will have to wait and see how it affects
things, as I won't know for a week or so.
Select time has never been a problem, the DB has always been very fast, it's the
inser
Hi,
My name is Alex Turner and I work for a small Tech company in Pottstown PA. We run
Postgresql on a number of systems for a variety of different applications, and it has
been a joy to deal with all around, working fast and reliably for over 2 years.
We recently upgraded from RedHat 7.2 to R
