On Sun, May 4, 2008 at 5:11 PM, Hans Zaunere <lists@zaunere.com> wrote:
> Hello,
>
> 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'
Wait, are you really creating a .csv file in shared memory? Can such
a thing even work?
If you're not creating a file in /dev/shm, where is it being built?
On the main OS drive? the battery backed cached RAID array?