-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 19 Dec 2007 13:50:29 -0500 (EST) Greg Smith <gsmith@xxxxxxxxxxxxx> wrote: > > With PG 8.2 and 8.3, is it still pretty much limited to 8 cores > > making 2 of the quad core Xeons redundant or detrimental? > > Where'd you get the idea 8 cores was a limit? As cores go up > eventually you run out of disk or memory bandwidth, but how that > plays out is very application dependant and there's no hard line > anywhere. Actually this is not true. Although I have yet to test 8.3. It is pretty much common knowledge that after 8 cores the acceleration of performance drops with PostgreSQL... This has gotten better every release. 8.1 for example handles 8 cores very well, 8.0 didn't and 7.4 well.... :) Sincerely, Joshua D. Drake - -- The PostgreSQL Company: Since 1997, http://www.commandprompt.com/ Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHaWoJATb/zqfZUUQRAgMeAJ9RS7BLAowXpJTbXuufJhIATj9gaACgrH6x LRVDPbyIvn71ANra2yiXmgY= =8QVl -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 6: explain analyze is your friend
