Re: 8.2.3 AutoVacuum not running

Поиск
Список
Период
Сортировка
От Schwenker, Stephen
Тема Re: 8.2.3 AutoVacuum not running
Дата
Msg-id FBEF1EF7B7E5B649AB1C684991223C6E10230A@tmg-mail2.torstar.net
обсуждение исходный текст
Ответ на 8.2.3 AutoVacuum not running  ("Schwenker, Stephen" <SSchwenker@thestar.ca>)
Список pgsql-general
Hey,  I've just found something else.  When I compiled postgresql, I assumed that because it compiled then it was a supported system.  This was on the first line of the configure output.
 
checking build system type... x86_64-unknown-linux-gnu
 
I've looked at the supported systems list and the x86_64 doesn't appear to be supported.  Can someone help me figure out how to make that system type to get supported?  Maybe I can turn on some debugging to figure out why it's not running.  I'm willing to put in some time to figure it out.
 
Thank you,
 
 
Steve.


From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Fri 06/04/2007 1:21 PM
To: Schwenker, Stephen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] 8.2.3 AutoVacuum not running

"Schwenker, Stephen" <SSchwenker@thestar.ca> writes:
> I've just compiled an instance of Postgresql 8.2.3 on a new linux box
> and have added some databases to it.  I've noticed however that the
> autovacuum is not running.

How sure are you of that?  Check pg_stat_all_tables to see if the
last_autovacuum column is changing.

                        regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Alan Hodgson
Дата:
Сообщение: Re: Problem with copying data
Следующее
От: "filippo"
Дата:
Сообщение: Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose)