X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 45D82529F8 for ; Tue, 19 Jul 2005 16:22:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10783-09 for ; Tue, 19 Jul 2005 19:22:16 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.197]) by svr1.postgresql.org (Postfix) with ESMTP id 845C652A62 for ; Tue, 19 Jul 2005 16:22:14 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id i35so1264259wra for ; Tue, 19 Jul 2005 12:22:14 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Z35hxky/1nuUl1h554gAwOeHoL+fHeQOdYBmJbmpFfJcQ5UnGcEBrj/ZYlHqQKkTo467ESS+fd/XuB9VaroSCLDtfO/MQp+r9mhOI5e4FwwRIzVdU7XGGfJXTHIIyLruBNl2+hMkpf+zpnOCzctf1SGYA/q2FQAdw7EH0Gxum88= Received: by 10.54.107.2 with SMTP id f2mr851530wrc; Tue, 19 Jul 2005 12:22:07 -0700 (PDT) Received: by 10.54.120.11 with HTTP; Tue, 19 Jul 2005 12:22:07 -0700 (PDT) Message-ID: <59d991c4050719122213ac3d81@mail.gmail.com> Date: Tue, 19 Jul 2005 15:22:07 -0400 From: Christopher Petrilli Reply-To: Christopher Petrilli To: Tom Lane Subject: Re: Impact of checkpoint_segments under continual load conditions Cc: PFC , Vivek Khera , pgsql-performance@postgresql.org In-Reply-To: <8375.1121799193@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <59d991c4050717100874c08a86@mail.gmail.com> <4541.1121788647@sss.pgh.pa.us> <59d991c40507190930244ba9bb@mail.gmail.com> <7224.1121791328@sss.pgh.pa.us> <59d991c4050719095440cd3de5@mail.gmail.com> <7436.1121792725@sss.pgh.pa.us> <59d991c405071910133e28031a@mail.gmail.com> <7843.1121796596@sss.pgh.pa.us> <59d991c40507191148e6f9ec5@mail.gmail.com> <8375.1121799193@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.145 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/317 X-Sequence-Number: 13558 On 7/19/05, Tom Lane wrote: > Christopher Petrilli writes: > > On 7/19/05, Tom Lane wrote: > >> How *exactly* are you invoking psql? >=20 > > It is a subprocess of a Python process, driven using a pexpect > > interchange. I send the COPY command, then wait for the '=3D#' to come > > back. >=20 > Some weird interaction with pexpect maybe? Try adding "-n" (disable > readline) to the psql command switches. Um... WOW! =3D=3D> pgsql_benchmark_803_bigbuffers10000_noreadline.txt <=3D=3D 0 0.0319459438324 0.0263829231262 1 0.0303978919983 0.0263390541077 2 0.0306499004364 0.0273139476776 3 0.0306959152222 0.0270659923553 4 0.0307791233063 0.0278429985046 5 0.0306351184845 0.0278820991516 6 0.0307800769806 0.0335869789124 7 0.0408310890198 0.0370559692383 8 0.0371310710907 0.0344209671021 9 0.0372560024261 0.0334041118622 =3D=3D> pgsql_benchmark_803_bigbuffers10000.txt <=3D=3D 0 0.0352520942688 0.149132013321 1 0.0320160388947 0.146126031876 2 0.0307128429413 0.139330863953 3 0.0306718349457 0.139590978622 4 0.0307030677795 0.140225172043 5 0.0306420326233 0.140012979507 6 0.0307261943817 0.139672994614 7 0.0307750701904 0.140661001205 8 0.0307800769806 0.141661167145 9 0.0306720733643 0.141198158264 =20 First column is iteration, second is "gen time" to generate the load file, and 3rd is "load time". It doesn't stay QUITE that low, but it stays lower... quite a bit.=20 We'll see what happens over time. Chris --=20 | Christopher Petrilli | petrilli@gmail.com