Search Postgresql Archives

Out of memory error during updating huge table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'm trying to update a table in transaction mode with
300 million records in it, and I'm getting an out of
memory error.

ERROR: out of memory
DETAIL: Failed on request of size 32.

In transaction mode, I first delete all the records in
the table and then try to use COPY to populate it
again with the new data from a file. The out of memory
error happens during the COPY.

Any thoughts? Is there a way to get around this?
Thanks a lot!

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux