Re: Mistake in documentation? ANALYZE on partitioned tables - Mailing list pgsql-general

From Tom Lane
Subject Re: Mistake in documentation? ANALYZE on partitioned tables
Date
Msg-id 17796.1417624923@sss.pgh.pa.us
Whole thread Raw
In response to Mistake in documentation? ANALYZE on partitioned tables  (pinker <pinker@onet.eu>)
List 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 by date:

Previous
From: Tim Schäfer
Date:
Subject: Re: Auto vacuum not running -- Could not bind socket for statistics collector
Next
From: mongoose
Date:
Subject: Re: Merge rows based on Levenshtein distance