Re: PL/pgSQL memory consumption?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dawid Kuroczko" <qnex42(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: PL/pgSQL memory consumption?
Date: 2008-02-22 14:54:15
Message-ID: 3216.1203692055@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Dawid Kuroczko" <qnex42(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lucas Sanabio 2008-02-22 15:02:58 Re: Table was deleted but it still been treated as not
Previous Message Raul Andres Duque 2008-02-22 14:42:39 Re: FW: [ADMIN] Clave usuario postgres