

Tom Lane wrote:

>bpalmer <bpalmer@crimelabs.net> writes:
>
>>Is there a way to ask pgsql how much memory, sort memory,  etc is being
>>used by pgsql at a given time (like in a system table or something)?
>>
>
>Um ... have you considered top, sar, or the other sysadmin tools your
>platform may provide?
>
top knows nothing about sort memory or internal cache/buffer sizes.

------------
Hannu



Thu, 15 Nov 2001 08:59:25 +0500
Hannu Krosing <hannu@sid.tm.ee>
Re: Shared memory use?
Is there a way to ask pgsql how much memory, sort memory,  etc is being
used by pgsql at a given time (like in a system table or something)?

Thanks,
- Brandon


----------------------------------------------------------------------------
 c: 646-456-5455                                            h: 201-798-4983
 b. palmer,  bpalmer@crimelabs.net           pgp:crimelabs.net/bpalmer.pgp5


Thu, 15 Nov 2001 00:15:55 -0500 (EST)
bpalmer <bpalmer@crimelabs.net>
Shared memory use?
bpalmer <bpalmer@crimelabs.net> writes:
> Is there a way to ask pgsql how much memory, sort memory,  etc is being
> used by pgsql at a given time (like in a system table or something)?

Um ... have you considered top, sar, or the other sysadmin tools your
platform may provide?

			regards, tom lane

Thu, 15 Nov 2001 00:46:19 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Shared memory use? 