On Wed, Oct 11, 2006 at 10:27:26AM -0400, Bucky Jordan wrote: > Also, I'm guessing this has already come up at some point, but what > about allowing PG to do some stat collection during queries? If you're > touching a lot of data (such as an import process) wouldn't it be more > efficient (and perhaps more accurate) to collect stats then, rather than > having to re-scan? It would be nice to be able to turn this on/off on a > per query basis, seeing as it could have pretty negative impacts on OLTP > performance...
I suspect that could be highly useful in data warehouse environments where you're more likely to have to sequential scan a table. It would be interesting to have it so that a sequential scan that will run to completion also collects stats along the way. -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
