Re: Is the database being VACUUMed?

From: "C(dot) Bensend" <benny(at)bennyvision(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Is the database being VACUUMed?
Date: 2006-02-10 21:32:24
Message-ID: 4167.134.244.169.17.1139607144.squirrel@webmail.stinkweasel.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> Well, you have to turn on the stats collector, so you will pay a little
> bit of a performance penalty for that. I doubt you'll notice it unless
> you're really close to the edge. You do have to restart the database to
> enable the stats collector if it's off. The pg_stat_activity stuff is
> pretty essential for debugging problems in the database.

I already have the stats collector on, so that's OK.

And my database is very simple, very much my own research project,
so bouncing it is no problem.

This looks like it will solve my problem nicely. Thanks to all
of you!

Benny

--
"'And you've got 10 gig of files to put through our mail system?' I
ask, squeezing my mouse in a non-approved manner." -- BOFH, 2006-01

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Frost 2006-02-11 00:04:27 Re: performance question related to pgsql
Previous Message david drummard 2006-02-10 21:26:07 Re: performance question related to pgsql