pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
monitoring free space map usage without VACUUM
2+ messages / 2 participants
[nested] [flat]

* monitoring free space map usage without VACUUM
@ 2008-01-14 16:13  Peter Koczan <pjkoczan@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Peter Koczan @ 2008-01-14 16:13 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

I'm looking into adding things to the way I monitor pgsql
installations. One of them was free space map stuff. Is there a way to
get free space information (especially used free space) without having
to screen-scrape the output of VACUUM VERBOSE? I know you can get the
allocated fsm pages from "show max_fsm_pages", but I'd like something
along the lines of "show needed_fsm_pages". Is there anything that can
do this? i don't care if the data is a little stale, I'd just like to
have a rough picture of free space map settings and usage.

Peter



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: monitoring free space map usage without VACUUM
@ 2008-01-14 16:37  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Peter Koczan <pjkoczan@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2008-01-14 16:37 UTC (permalink / raw)
  To: Peter Koczan <pjkoczan@gmail.com>; +Cc: pgsql-admin

"Peter Koczan" <pjkoczan@gmail.com> writes:
> I'm looking into adding things to the way I monitor pgsql
> installations. One of them was free space map stuff. Is there a way to
> get free space information (especially used free space) without having
> to screen-scrape the output of VACUUM VERBOSE?

In 8.2 there's a contrib/pg_freespacemap module that would help.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-01-14 16:37 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-14 16:13 monitoring free space map usage without VACUUM Peter Koczan <pjkoczan@gmail.com>
2008-01-14 16:37 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox