Hi,
I am trying to restore a table out of a dump, and I get an 'out of
memory' error.
The table I want to restore is 5GB big.
Here is the exact message :
[EMAIL PROTECTED]:/home/backup-sas$ pg_restore -F c -a -d axabas -t cabmnt
axabas.dmp
pg_restore: [archiver (db)] Error while PROCESSING TOC
Hello,
I'm having problems with the following bad performing select-statement
in a trigger-function (on update before):
...
for c in
select id_country, sum(cost) as sum_cost
from costs
where id_user = p_id_user
and id_state = 1
and date(request) between p_begin and p_until
On Thu, 4 Dec 2008, Matthew Wakeling wrote:
http://archives.postgresql.org/pgsql-bugs/2008-11/msg00180.php
Thanks, that does explain everything.
Oh right, yes. It explains everything *except* the fact that the backend
is still holding onto all the RAM after the query is finished. Could the
On Wed, 3 Dec 2008, hubert depesz lubaczewski wrote:
Check bug report from 2008-11-28, by Grzegorz Jaskiewicz:
query failed, not enough memory on 8.3.5
http://archives.postgresql.org/pgsql-bugs/2008-11/msg00180.php
Thanks, that does explain everything. So workmem is not a hard limit on
the am
