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 3B63852A1E for ; Wed, 20 Jul 2005 12:53:38 -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 04654-05 for ; Wed, 20 Jul 2005 15:53:33 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.196]) by svr1.postgresql.org (Postfix) with ESMTP id 3C841529F1 for ; Wed, 20 Jul 2005 12:53:32 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id i21so1465165wra for ; Wed, 20 Jul 2005 08:53:32 -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=K5jEmBr3RI051uvTjdt2tBoxgsiBxxpqw8Q79l/Bbx3IUDg7Jj8E14ab4fk4m9+LdooLzgChlBryzu1x407C/OypdE6xPIpgck5nQ0EdTTFViStzlFuG8rz+m9jWPt+Qsgl7r7hKS1gw9adWX85ZwZZRlHBcyetBp8ROq6zhTyU= Received: by 10.54.13.37 with SMTP id 37mr139716wrm; Wed, 20 Jul 2005 08:52:52 -0700 (PDT) Received: by 10.54.120.11 with HTTP; Wed, 20 Jul 2005 08:52:52 -0700 (PDT) Message-ID: <59d991c405072008523c6914bc@mail.gmail.com> Date: Wed, 20 Jul 2005 11:52:52 -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: <59d991c4050719122213ac3d81@mail.gmail.com> 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> <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> <59d991c4050719122213ac3d81@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.143 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/335 X-Sequence-Number: 13576 On 7/19/05, Christopher Petrilli wrote: > On 7/19/05, Tom Lane wrote: > > Christopher Petrilli writes: > > > On 7/19/05, Tom Lane wrote: > > >> How *exactly* are you invoking psql? > > > > > It is a subprocess of a Python process, driven using a pexpect > > > interchange. I send the COPY command, then wait for the '=3D#' to com= e > > > back. > > > > Some weird interaction with pexpect maybe? Try adding "-n" (disable > > readline) to the psql command switches. >=20 > Um... WOW! > It doesn't stay QUITE that low, but it stays lower... quite a bit. > We'll see what happens over time. here's a look at the difference: http://blog.amber.org/diagrams/pgsql_readline_impact.png I'm running additional comparisons AFTER clustering and analyzing the table= s...=20 Chris --=20 | Christopher Petrilli | petrilli@gmail.com