Re: CSStorm occurred again by postgreSQL8.2. (Re: poor performance with Context Switch Storm at TPC-W.)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Katsuhiko Okano <okano(dot)katsuhiko(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: CSStorm occurred again by postgreSQL8.2. (Re: poor performance with Context Switch Storm at TPC-W.)
Date: 2006-07-18 16:51:53
Message-ID: 5126.1153241513@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Katsuhiko Okano <okano(dot)katsuhiko(at)oss(dot)ntt(dot)co(dot)jp> writes:
> It does not solve, even if it increases the number of NUM_SUBTRANS_BUFFERS.
> The problem was only postponed.

Can you provide a reproducible test case for this?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-07-18 16:59:11 Re: [PATCHES] Proposed patch for contrib/cube
Previous Message Tom Lane 2006-07-18 16:48:21 Re: missing tuplestore_gettuple

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-07-18 16:59:11 Re: [PATCHES] Proposed patch for contrib/cube
Previous Message Andrew Dunstan 2006-07-18 16:20:56 Re: [PATCHES] Proposed patch for contrib/cube