X-Original-To: pgsql-hackers-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 93D489FA4A7 for ; Wed, 19 Jul 2006 07:54:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 37437-08 for ; Wed, 19 Jul 2006 10:54:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from cronos.madness.at (madness.at [217.196.146.217]) by postgresql.org (Postfix) with ESMTP id 705099FA47F for ; Wed, 19 Jul 2006 07:54:03 -0300 (ADT) Received: from gateway.conova.com ([213.153.32.181] helo=[192.168.1.61]) by cronos.madness.at with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.62 (FreeBSD)) (envelope-from ) id 1G39gg-0002F6-NB; Wed, 19 Jul 2006 12:53:58 +0200 Message-ID: <44BE0F41.70305@kaltenbrunner.cc> Date: Wed, 19 Jul 2006 12:53:53 +0200 From: Stefan Kaltenbrunner User-Agent: Thunderbird 1.5.0.2 (X11/20060516) MIME-Version: 1.0 To: Katsuhiko Okano CC: tgl@sss.pgh.pa.us, pgsql-hackers@postgresql.org Subject: Re: CSStorm occurred again by postgreSQL8.2. (Re: poor References: <200607112009.FED09315.TLPPUBIBOPuVLJL@oss.ntt.co.jp> <20060711135951.GA3995@surnet.cl> <200607141457.CFC04165.PBLJLPVTILUBOPu@oss.ntt.co.jp> <200607181650.EDC81237.LOBJUTPuIPPBLLV@oss.ntt.co.jp> <5126.1153241513@sss.pgh.pa.us> <200607191935.JGI17110.TIJuLLLPPBOUVBP@oss.ntt.co.jp> In-Reply-To: <200607191935.JGI17110.TIJuLLLPPBOUVBP@oss.ntt.co.jp> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/771 X-Sequence-Number: 86626 Katsuhiko Okano wrote: > "Tom Lane " wrote: >> Katsuhiko Okano 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? > > Seven machines are required in order to perform measurement. > (DB*1,AP*2,CLient*4) > Enough work load was not able to be given in two machines. > (DB*1,{AP+CL}*1) > > > It was not able to reappear to a multiplex run of pgbench > or a simple SELECT query. > TPC-W of a work load tool used this time is a full scratch. > Regrettably it cannot open to the public. > If there is a work load tool of a free license, I would like to try. FYI: there is a free tpc-w implementation done by Jan available at: http://pgfoundry.org/projects/tpc-w-php/ Stefan