Re: Postgres Connections Requiring Large Amounts of Memory

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