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?
|
Список | 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
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@neadwerx.com | www.neadwerx.com
moshe@neadwerx.com | www.neadwerx.com
"Quality is not an act, it is a habit." -- Aristotle
В списке pgsql-general по дате отправления: