Re: Is the database being VACUUMed? - Mailing list pgsql-admin

From C. Bensend
Subject Re: Is the database being VACUUMed?
Date
Msg-id 4167.134.244.169.17.1139607144.squirrel@webmail.stinkweasel.net
Whole thread Raw
In response to Re: Is the database being VACUUMed?  (Brad Nicholson <bnichols@ca.afilias.info>)
List 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


pgsql-admin by date:

Previous
From: david drummard
Date:
Subject: Re: performance question related to pgsql
Next
From: Stephen Frost
Date:
Subject: Re: performance question related to pgsql