"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