Re: pg_dump ANALYZE statements

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump ANALYZE statements
Date: 2007-01-23 06:08:55
Message-ID: 10748.1169532535@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Jim C. Nasby" <jim(at)nasby(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2007-01-23 06:20:22 Re: Updateable cursors
Previous Message Lukas Kahwe Smith 2007-01-23 06:00:51 Re: Updateable cursors