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
|
| Список | 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 по дате отправления: