How to control memory usage of postgresql

From: André de Camargo Fernandes <andrei(at)lightcomm(dot)com(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to control memory usage of postgresql
Date: 2006-02-08 21:36:40
Message-ID: 43EA6468.3060708@lightcomm.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
I have a postgreSQL database running and sometime ago there was a small
problem, some query running inside the server was onsuming too much
memory, so the server (a DEBIAN LINUX) became out of memory.
To solve that, the server must drop all queries that start using a lot
of memory, before the server get out of memory again, how can I do that?

Thanks in advance,
Andre.

Browse pgsql-novice by date

  From Date Subject
Next Message Srinivas Iyyer 2006-02-09 17:08:47 SQL Query gone wrong.. please help
Previous Message Jeffrey Melloy 2006-02-08 20:32:44 Re: SQL Question