Re: Something Weird Going on with VACUUM ANALYZE

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Something Weird Going on with VACUUM ANALYZE
Дата
Msg-id CAMkU=1zxhPBr5-QXjZ54UuH7YvrkqddtAe6FkyWk31sP+kV4Vw@mail.gmail.com
обсуждение исходный текст
Ответ на Something Weird Going on with VACUUM ANALYZE  (Shaun Thomas <sthomas@optionshouse.com>)
Ответы Re: Something Weird Going on with VACUUM ANALYZE  (Shaun Thomas <sthomas@optionshouse.com>)
Список pgsql-general
On Tue, Sep 17, 2013 at 1:39 PM, Shaun Thomas <sthomas@optionshouse.com> wrote:
Hey,

This is PostgreSQL 9.1.9.

 
...
 
Apparently something magical happened last Friday, and now analyze is broken somehow? Am I missing something, here? The log claims everything worked out OK:

2013-09-17 03:20:37 CDT|STATEMENT:  VACUUM (VERBOSE, ANALYZE);
2013-09-17 03:37:31 CDT|LOG:  duration: 2246467.567 ms  statement: VACUUM (VERBOSE, ANALYZE);

These are from the same pid doing the vacuum. What's weird, is that the lines don't match up in time.  The reported duration is 37 minutes, and since the vacuum launches at 3:00am, it matches with the last line. If that's the case, what on Earth is that line at 3:20 all about?

That line is the final line of a multi-line log entry.  To know what it is about, you need to look at the lines before it in the logfile.  Perhaps it is failing to obtain a lock or something.

Cheers,

Jeff

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

Предыдущее
От: "Gabriel E. Sánchez Martínez"
Дата:
Сообщение: Re: nested partitioning
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Query - CPU issue