Re: PL/pgSQL memory consumption? - Mailing list pgsql-admin

From Tom Lane
Subject Re: PL/pgSQL memory consumption?
Date
Msg-id 3216.1203692055@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL memory consumption?  ("Dawid Kuroczko" <qnex42@gmail.com>)
Responses Re: PL/pgSQL memory consumption?  ("Peter Koczan" <pjkoczan@gmail.com>)
Re: PL/pgSQL memory consumption?  ("Dawid Kuroczko" <qnex42@gmail.com>)
List pgsql-admin
"Dawid Kuroczko" <qnex42@gmail.com> writes:
> I have recently found a nice utility called memstat (which shows how
> much of private
> (not shared)) memory each process uses.  What kind of surprised me was
> the amount
> of memory that is used by PL/pgSQL (one more reason not to provide it
> by default? ;-)).

Why should we put any credence whatsoever in these numbers?
I rather doubt that "memstat" knows anything about our palloc
mechanism, so I don't see how it could possibly give reliable
answers about how much memory one portion or another of Postgres
is using.

Having said that, it would be interesting to know exactly what it
*is* measuring.

            regards, tom lane

pgsql-admin by date:

Previous
From: if
Date:
Subject: Re: vaccuming very large table problem
Next
From: "Lucas Sanabio"
Date:
Subject: Re: Table was deleted but it still been treated as not