two memory-consuming postgres processes

From: Alexy Khrabrov <deliverable(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: two memory-consuming postgres processes
Date: 2008-05-02 19:24:35
Message-ID: A728C858-76CF-473F-917B-3C9EA4AA75CF@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greetings -- I have an UPDATE query updating a 100 million row table,
and allocate enough memory via shared_buffers=1500MB. However, I see
two processes in top, the UPDATE process eating about 850 MB and the
writer process eating about 750 MB. The box starts paging. Why is
there the writer taking almost as much space as the UPDATE, and how
can I shrink it?

Cheers,
Alexy

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-05-02 19:30:38 Re: two memory-consuming postgres processes
Previous Message Justin 2008-05-02 17:11:34 Re: Pros and Cons of 8.3.1