Re: Is the database being VACUUMed?

Поиск
Список
Период
Сортировка
От C. Bensend
Тема Re: Is the database being VACUUMed?
Дата
Msg-id 4167.134.244.169.17.1139607144.squirrel@webmail.stinkweasel.net
обсуждение исходный текст
Ответ на Re: Is the database being VACUUMed?  (Brad Nicholson <bnichols@ca.afilias.info>)
Список 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 по дате отправления:

Предыдущее
От: david drummard
Дата:
Сообщение: Re: performance question related to pgsql
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: performance question related to pgsql