Postmaster memory problem

From: "Ricardo J(dot)C(dot)Coelho" <pulsar(at)truenet-ce(dot)com(dot)br>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Postmaster memory problem
Date: 1999-02-05 02:01:42
Message-ID: 01BE509A.D81CBBE0.pulsar@truenet-ce.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Does anybody use a single query affecting many rows (100,000 or more) ?

I have a table with 500,000 rows. If I update all rows with one query (For
example: update table set field='A';), postmaster will allocate the memory
of the computer (including swap area), until "palloc memory exhauted". The
same thing happens with COPY command. To load this table I splited the text
file in many smaller files.

What did I do wrong during Pgsql compilation ? I'm using RedHat 5.2 (Intel)
and Pgsql 6.4.2

Is there a way to limit the amount of memory used by postmaster ? I tried
ulimit (unix command) and postmaster option but it aborted.

Thanks,

Ricardo Coelho.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ricardo J.C.Coelho 1999-02-05 02:02:28 Index problem with Timestamp fields
Previous Message Ricardo J.C.Coelho 1999-02-05 01:49:40 Postmaster memory problem