Re: Vacuum cancels autovacuum error message confusing?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Vacuum cancels autovacuum error message confusing?
Дата
Msg-id 20100420225147.GF3229@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Vacuum cancels autovacuum error message confusing?  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Vacuum cancels autovacuum error message confusing?
Список pgsql-hackers
Josh Berkus wrote:
> 
> > Isn't this just because you ran the postmaster in the same terminal as
> > pgbench?
> 
> Right, but those messages appear in the logs as well.  I'm thinking of
> the reaction of anyone reading the logs ... since they wouldn't, at that
> time, know about a manual vacuum that happened.

Eh?  I think they could examine pg_stat_user_tables to see the last
vacuum time of the table ... in fact, wouldn't one do exactly that
before reaching any conclusions about this error message?

Or are you saying that each and every VACUUM should emit a LOG message?
You know, so that the user knows that a vacuum happened, manual or
otherwise.

That said, I'm not wedded to that message wording; feel free to propose
something better.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Thoughts on pg_hba.conf rejection
Следующее
От: Tom Lane
Дата:
Сообщение: Should database = all in pg_hba.conf match a replication connection?