Postgres Pro
Downloads
Home   >   mailing lists

two memory-consuming postgres processes - Mailing list pgsql-performance

From Alexy Khrabrov
Subject two memory-consuming postgres processes
Date
Msg-id A728C858-76CF-473F-917B-3C9EA4AA75CF@gmail.com
Whole thread Raw
Responses Re: two memory-consuming postgres processes  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: two memory-consuming postgres processes  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Pros and Cons of 8.3.1
Next
From: "Scott Marlowe"
Date:
Subject: Re: two memory-consuming postgres processes