Postmaster memory problem - Mailing list pgsql-general

From Ricardo J.C.Coelho
Subject Postmaster memory problem
Date
Msg-id 01BE5099.394082A0.pulsar@truenet-ce.com.br
Whole thread Raw
List 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.

pgsql-general by date:

Previous
From: Sebestyen Zoltan
Date:
Subject: Re: [GENERAL] vacuum problems
Next
From: "Ricardo J.C.Coelho"
Date:
Subject: Index problem with Timestamp fields