Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Out of memory error during updating huge table
- From: Gabor Siklos <siklosg(at)yahoo(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Out of memory error during updating huge table
- Date: Fri, 10 Feb 2006 07:58:56 -0800 (PST)
- Message-id: <20060210155856.62005.qmail@web54215.mail.yahoo.com> <text/plain>
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
- Follow-Ups:
- Re: Out of memory error during updating huge table
- From: Tom Lane
- Re: Out of memory error during updating huge table
- Prev by Date: Re: Is there a way to limit CPU usage per user
- Next by Date: Re: Is there a way to limit CPU usage per user
- Previous by thread: "psql -At -F" export column from table to .csv
- Next by thread: Re: Out of memory error during updating huge table
- Indexes: