Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread 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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group