Re: feeding big script to psql - Mailing list pgsql-general

From Tom Lane
Subject Re: feeding big script to psql
Date
Msg-id 14740.1122947662@sss.pgh.pa.us
Whole thread Raw
In response to feeding big script to psql  (Havasvölgyi Ottó <h.otto@freemail.hu>)
List pgsql-general
=?ISO-8859-1?Q?Havasv=F6lgyi_Ott=F3?= <h.otto@freemail.hu> writes:
> I know it would be faster with COPY, but this is extremly slow, and the
> bottleneck is psql.
> What is the problem?

Hmm, does the Windows port have readline support, and if so does adding
the "-n" switch to the psql invocation fix the problem?  Or you could
try feeding the script with -f switch or \i rather than "psql <script".
Readline adds a fair amount of overhead, which is completely invisible
at human typing speeds but can be annoying when reading scripts.

            regards, tom lane

pgsql-general by date:

Previous
From: "Logan Bowers"
Date:
Subject: SELECT count(*) Generating Lots of Write Activity
Next
From: Tom Lane
Date:
Subject: Re: could not bind IPv6 socket