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

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 (view raw or flat)
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

pgsql-admin by date

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

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