Re: Mistake in documentation? ANALYZE on partitioned tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Mistake in documentation? ANALYZE on partitioned tables
Дата
Msg-id 17796.1417624923@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Mistake in documentation? ANALYZE on partitioned tables  (pinker <pinker@onet.eu>)
Список pgsql-general
pinker <pinker@onet.eu> writes:
> As I have read in  documentation
> <http://www.postgresql.org/docs/9.3/static/ddl-partitioning.html>   that "If
> you are using manual VACUUM or ANALYZE commands, don't forget that you need
> to run them on each partition individually. A command like: ANALYZE
> measurement; will only process the master table."

> But when I run ANALYZE VERBOSE orders; (test table with 12 partitions) I
> get:
> All partitions were processed...
> So I guess: mistake in documentation?

No.  All the partitions were *scanned*, to generate whole-inheritance-tree
statistics for the parent table.  But this did not update stats associated
with the individual child tables.

            regards, tom lane


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

Предыдущее
От: Tim Schäfer
Дата:
Сообщение: Re: Auto vacuum not running -- Could not bind socket for statistics collector
Следующее
От: mongoose
Дата:
Сообщение: Re: Merge rows based on Levenshtein distance