Re: how to avoid that a postgres session eats up all the memory

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Clemens Schwaighofer <clemens(dot)schwaighofer(at)tequila(dot)jp>
Cc: Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: how to avoid that a postgres session eats up all the memory
Date: 2009-01-23 09:48:42
Message-ID: 2f4958ff0901230148s5862f677u3e5d60bcb32b06b9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

try raising work_mem before the delete; on single connection :

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Schwaighofer Clemens 2009-01-23 10:21:23 Re: how to avoid that a postgres session eats up all the memory
Previous Message Carlos Gonzalez-Cadenas 2009-01-23 09:10:55 Re: deductive databases in postgreSQL