Re: COPY Performance - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY Performance
Date
Msg-id 12739.1209944461@sss.pgh.pa.us
Whole thread Raw
In response to COPY Performance  ("Hans Zaunere" <lists@zaunere.com>)
Responses Re: COPY Performance
List pgsql-general
"Hans Zaunere" <lists@zaunere.com> writes:
> We're using a statement like this to dump between 500K and >5 million rows.

> COPY(SELECT SomeID FROM SomeTable WHERE SomeColumn > '0')
>   TO '/dev/shm/SomeFile.csv'

> Upon first run, this operation can take several minutes.  Upon second run,
> it will be complete in generally well under a minute.

Hmmm ... define "first" versus "second".  What do you do to return it to
the slow state?

            regards, tom lane

pgsql-general by date:

Previous
From: "Hans Zaunere"
Date:
Subject: COPY Performance
Next
From: Scott Ribe
Date:
Subject: Race condition with notifications