Re: pg_dump ANALYZE statements - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump ANALYZE statements
Date
Msg-id 10748.1169532535@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump ANALYZE statements  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:
> On Mon, Jan 22, 2007 at 03:40:17PM +0000, Simon Riggs wrote:
>> This would add a table-specific ANALYZE statement following each table's
>> actions.

> It'd probably be best to put it before any index creating activities,

No, because then you'd fail to accumulate any stats on partial or
functional indexes.  There's been talk of using the presence of
multi-column indexes to guide creation of cross-column statistics, too.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Lukas Kahwe Smith
Date:
Subject: Re: Updateable cursors
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Updateable cursors