Re: Can you spot the difference?

Поиск
Список
Период
Сортировка
От Moshe Jacobson
Тема Re: Can you spot the difference?
Дата
Msg-id CAJ4CxLk5gvkVYT1c0xGn-Qh-QXNsDUZKXW8ZssOZsxuLfNUz8w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can you spot the difference?  (Adrian Klaver <adrian.klaver@gmail.com>)
Ответы Re: Can you spot the difference?  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general

On Tue, Apr 16, 2013 at 7:29 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
"
The autovacuum daemon, if enabled, will automatically issue ANALYZE commands whenever the content of a table has changed sufficiently. However, administrators might prefer to rely on manually-scheduled ANALYZE operations, particularly if it is known that update activity on a table will not affect the statistics of "interesting" columns. The daemon schedules ANALYZE strictly as a function of the number of rows inserted or updated; it has no knowledge of whether that will lead to meaningful statistical changes.
"

So at a guess there has not been enough churn on the table.

So pg_restore's COPY would not trigger the ANALYZE? That seems wrong.


--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@neadwerx.com | 
www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle

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

Предыдущее
От: Philipp Kraus
Дата:
Сообщение: Re: dataset lock
Следующее
От: Dale Fukami
Дата:
Сообщение: Re: Mysterious table that exists but doesn't exist