Re: COPY Performance

On Sun, May 4, 2008 at 5:11 PM, Hans Zaunere <lists@[EMAIL PROTECTED]
> 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?

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