Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3BB7A2E002C for ; Thu, 20 Mar 2008 16:50:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 51951-01-10 for ; Thu, 20 Mar 2008 16:49:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from is.rice.edu (is.rice.edu [128.42.42.24]) by postgresql.org (Postfix) with ESMTP id 136152E0085 for ; Thu, 20 Mar 2008 16:49:13 -0300 (ADT) Received: from scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160]) by is.rice.edu (Postfix) with ESMTP id B2EC641878; Thu, 20 Mar 2008 14:48:21 -0500 (CDT) Received: from is.rice.edu ([128.42.42.24]) by scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160]) (amavisd-new, port 10024) with ESMTP id 07895-06; Thu, 20 Mar 2008 13:48:21 -0600 (CST) Received: by is.rice.edu (Postfix, from userid 18612) id 04ADB41876; Thu, 20 Mar 2008 14:48:20 -0500 (CDT) Date: Thu, 20 Mar 2008 14:48:20 -0500 From: Kenneth Marshall To: Decibel! Cc: Peter Eisentraut , pgsql-hackers@postgresql.org, Gregory Stark , Tom Lane , Martijn van Oosterhout Subject: Re: Maximum statistics target Message-ID: <20080320194820.GF27394@it.is.rice.edu> References: <200803071925.26532.peter_e@gmx.net> <12262.1205153194@sss.pgh.pa.us> <87ejaibspe.fsf@oxford.xeocode.com> <200803101926.43786.peter_e@gmx.net> <588963E3-CCD4-4549-B46E-56F3365F014C@decibel.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <588963E3-CCD4-4549-B46E-56F3365F014C@decibel.org> User-Agent: Mutt/1.5.16 (2007-06-09) X-Virus-Scanned: by amavis-2.2.1 at scan1.mail.rice.edu X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/772 X-Sequence-Number: 115573 On Thu, Mar 20, 2008 at 11:17:10AM -0500, Decibel! wrote: > On Mar 10, 2008, at 1:26 PM, Peter Eisentraut wrote: > > At some point I think it makes a lot more sense to just have VACUUM gather > stats as it goes, rather than have ANALYZE generate a bunch of random IO. > > BTW, when it comes to the case of the OP, perhaps we can build enough > intelligence for the system to understand when the stats follow some type > of pattern (ie: a geometric distribution), and store the stats differently. > -- > Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org > Give your computer some brain candy! www.distributed.net Team #1828 > +1 for opportunistically gathering stats during other I/O such as vacuums and sequential scans. It would be interesting to have a hook to allow processes to attach to the dataflow from other queries. Cheers, Ken