In response to Bob Dusek : > Hello, > > We're running Postgres 8.4.2 on Red Hat 5, on pretty hefty hardware... > > 4X E7420 Xeon, Four cores (for a total of 16 cores) > 2.13 GHz, 8M Cache, 1066 Mhz FSB > 32 Gigs of RAM > 15 K RPM drives in striped raid > > Things run fine, but when we get a lot of concurrent queries running, we see a > pretty good slow down. > > We don't have much experience with this sort of hardware. Does anyone have an > example config file we could use as a good starting point for this sort of > hardware? Have you tuned your postgresql.conf? (memory-parameter) Here are some links for you: 15:07 < akretschmer> ??performance 15:07 < rtfm_please> For information about performance 15:07 < rtfm_please> see http://revsys.com/writings/postgresql-performance.html 15:07 < rtfm_please> or http://wiki.postgresql.org/wiki/Performance_Optimization 15:07 < rtfm_please> or http://www.depesz.com/index.php/2007/07/05/how-to-insert-data-to-database-as-fast-as-possible/ HTH, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
