"Jim C. Nasby" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
