"Hans Zaunere" <lists@xxxxxxxxxxx> 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
