Re: Linux/PostgreSQL scalability issue - problem with 8 cores

From: David Boreham <david_list(at)boreham(dot)org>
To: James Mansion <james(at)mansionfamily(dot)plus(dot)com>
Cc: Jakub Ouhrabka <kuba(at)comgate(dot)cz>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Linux/PostgreSQL scalability issue - problem with 8 cores
Date: 2008-01-04 20:55:08
Message-ID: 477E9D2C.5070707@boreham.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

James Mansion wrote:
> Jakub Ouhrabka wrote:
>> How can we diagnose what is happening during the peaks?
> Can you try forcing a core from a bunch of the busy processes? (Hmm -
> does Linux have an equivalent to the useful Solaris pstacks?)
There's a 'pstack' for Linux, shipped at least in Red Hat distributions
(and possibly others,
I'm not sure). It's a shell script wrapper around gdb, so easily ported
to any Linux.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sergei Shelukhin 2008-01-06 03:00:00 concurrent inserts into two separate tables are very slow
Previous Message James Mansion 2008-01-04 20:46:52 Re: Linux/PostgreSQL scalability issue - problem with 8 cores