Re: [PERFORM] Performance degrade running on multicore computer

2009-11-23 Thread Dave Youatt
On 01/-10/-28163 11:59 AM, afancy wrote: > Hi, > > My PostgreSQL server has two CPUs (OS: Fedora 11), each with 4 cores. > Total is 8cores. Now I have several clients running at the same time > to do insert and update on the same table, each client having its own > connection. I have made two te

Re: [PERFORM] hyperthreaded cpu still an issue in 8.4?

2009-07-28 Thread Dave Youatt
* *Message-id*: http://archives.postgresql.org/pgsql-performance/2009-07/msg00293.php>> On Mon, 27 Jul 2009, Dave Youatt wrote: Greg, those are compelling numbers for the new Nehalem processors.

Re: [PERFORM] hyperthreaded cpu still an issue in 8.4?

2009-07-27 Thread Dave Youatt
On 01/-10/-28163 11:59 AM, Greg Smith wrote: > On Tue, 21 Jul 2009, Doug Hunley wrote: > >> Just wondering is the issue referenced in >> http://archives.postgresql.org/pgsql-performance/2005-11/msg00415.php >> is still present in 8.4 or if some tunable (or other) made the use of >> hyperthreading a

[PERFORM] linux, memory (mis)accounting/reporting, and the planner/optimizer

2009-01-21 Thread Dave Youatt
Apologies if this is a FAQ, but... Given linux's (mis)accounting/reporting of per-process memory, including shared memory (see for example this page: http://lwn.net/Articles/230975/) how does postgresql interpret and use the information that's provided? Does it use the information as-is? Does i