Re: Postgres Connections Requiring Large Amounts of Memory - Mailing list pgsql-performance

From Tom Lane
Subject Re: Postgres Connections Requiring Large Amounts of Memory
Date
Msg-id 17569.1055892101@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres Connections Requiring Large Amounts of Memory  (Dawn Hollingsworth <dmh@airdefense.net>)
List pgsql-performance
Dawn Hollingsworth <dmh@airdefense.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

pgsql-performance by date:

Previous
From: Dawn Hollingsworth
Date:
Subject: Re: Postgres Connections Requiring Large Amounts of Memory
Next
From: Tom Lane
Date:
Subject: Re: Interesting incosistent query timing