Re: Postgres Connections Requiring Large Amounts of Memory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dawn Hollingsworth <dmh(at)airdefense(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org,Ben Scherrey <scherrey(at)proteus-tech(dot)com>
Subject: Re: Postgres Connections Requiring Large Amounts of Memory
Date: 2003-06-17 23:21:41
Message-ID: 17569.1055892101@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-performance

Dawn Hollingsworth <dmh(at)airdefense(dot)net> writes:
> I just connected the user interface to the database. It only does
> selects on startup. It's connection jumped to a memory usage of 256M.
> It's not getting any larger but it's not getting any smaller either.

Um, are you sure that's actual memory usage? On some platforms "top"
seems to count the Postgres shared memory block as part of the address
space of each backend. How big is your shared memory block? (ipcs may
help here)

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-06-18 00:12:18 Re: [PERFORM] Interesting incosistent query timing
Previous Message Ernest E Vogelsinger 2003-06-17 23:01:09 Re: [PERFORM] Interesting incosistent query timing