Re: COPY Performance

"Hans Zaunere" <lists@[EMAIL PROTECTED]
> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general