pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joshua Marsh <icub3d@gmail.com>
To: pgsql-admin@postgresql.org
Subject: CLUSTER using more memory than expected
Date: Wed, 25 Oct 2006 10:13:59 -0600
Message-ID: <38242de90610250913s119e84c6rcf167edd74eadd60@mail.gmail.com> (raw)

The CLUSTER function seems to be using more memory than I expect.  Here is
what I get from top and from my config file:

from top:
27589 postgres  25   0 3943m 3.6g  11m R 99.9 61.6 639:19.41 postgres:
postgres data 127.0.0.1(42126) CLUSTER

from postgresql.conf
shared_buffers = 1000 #26214            # min 16, at least
max_connections*2, 8KB each
work_mem = 256000               # min 64, size in KB
maintenance_work_mem = 2097151  # min 1024, size in KB
#max_stack_depth = 2048         # min 100, size in KB

My version is: 8.0.3

Any ideas why this would be happening.  I tried a full restart and the same
thing happens.

Thanks,

Josh


-- 
This E-mail is covered by the Electronic Communications Privacy Act, 18
U.S.C. 2510-2521 and is legally privileged.

This information is confidential information and is intended only for the
use of the individual or entity named above. If the reader of this message
is not the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited.

view thread (5+ messages)  latest in thread

Message-ID: <38242de90610250913s119e84c6rcf167edd74eadd60@mail.gmail.com>
Permalink:  ../38242de90610250913s119e84c6rcf167edd74eadd60@mail.gmail.com/
Also on:    postgresql.org/message-id/38242de90610250913s119e84c6rcf167edd74eadd60@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: icub3d@gmail.com
  Subject: Re: CLUSTER using more memory than expected
  In-Reply-To: <38242de90610250913s119e84c6rcf167edd74eadd60@mail.gmail.com>
  References: <38242de90610250913s119e84c6rcf167edd74eadd60@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox