On 7/19/05, Christopher Petrilli <[EMAIL PROTECTED]> wrote: > On 7/19/05, Tom Lane <[EMAIL PROTECTED]> wrote: > > Christopher Petrilli <[EMAIL PROTECTED]> writes: > > > On 7/19/05, Tom Lane <[EMAIL PROTECTED]> 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 '=#' to come > > > back. > > > > Some weird interaction with pexpect maybe? Try adding "-n" (disable > > readline) to the psql command switches. > > 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 tables... Chris -- | Christopher Petrilli | [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org