Re: VACUUM messages without newlines

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: VACUUM messages without newlines
Дата
Msg-id 1275405940-sup-4136@alvh.no-ip.org
обсуждение исходный текст
Ответ на VACUUM messages without newlines  (Thom Brown <thombrown@gmail.com>)
Ответы Re: VACUUM messages without newlines  (Thom Brown <thombrown@gmail.com>)
Список pgsql-hackers
Excerpts from Thom Brown's message of mar jun 01 11:16:33 -0400 2010:
> This has annoyed me for some time, but it appears that in the VACUUM
> log, the line which says...
> 
> INFO: analyzing "%s.%s"
> 
> ...( and appears in pgsql/src/backend/commands/analyze.c lines 282 and
> 287  ) doesn't terminate with a newline, meaning the next message
> appears immediately after it.

The message pieces are sent separately.  They are only crammed in a
single line if the interface is using the old mechanism to extract error
message info; anything built after cca. 2002 should be reading fields
separately, and printing them in separate lines.

> The same goes for...
> 
> CPU %d.%02ds/%d.%02du sec elapsed %d.%02d sec

Now you can argue that this line is too long, but that's a different
problem than the one above.

> "%s": scanned %d of %u pages, containing %.0f live rows and %.0f dead
> rows; %d rows in sample, %.0f estimated total rows

This too.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


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

Предыдущее
От: Thom Brown
Дата:
Сообщение: VACUUM messages without newlines
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: dividing money by money