Postgres Pro
Downloads
Home   >   mailing lists

Re: how to avoid that a postgres session eats up all the memory - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: how to avoid that a postgres session eats up all the memory
Date
Msg-id 2f4958ff0901230148s5862f677u3e5d60bcb32b06b9@mail.gmail.com
Whole thread Raw
In response to Re: how to avoid that a postgres session eats up all the memory  (Clemens Schwaighofer <clemens.schwaighofer@tequila.jp>)
Responses Re: how to avoid that a postgres session eats up all the memory  (Schwaighofer Clemens <clemens.schwaighofer@tequila.jp>)
List pgsql-general
Tree view 
try raising work_mem before the delete; on single connection :

set work_mem=512000; DELETE FROM ......;

pgsql-general by date:

Previous
From: Nick Withers
Date:
Subject: Re: Segmentation fault in backend/access/heap/pruneheap.c: heap_page_prune_opt() calling PageIsPrunable () with NULL page on FreeBSD / PowerPC
Next
From: Schwaighofer Clemens
Date:
Subject: Re: how to avoid that a postgres session eats up all the memory