Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 881859FB1F2 for ; Wed, 20 Jun 2007 15:15:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 53358-03 for ; Wed, 20 Jun 2007 15:15:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 28DC59FBD32 for ; Wed, 20 Jun 2007 15:15:16 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1I14i4-0001jT-Bg for pgsql-performance@postgresql.org; Wed, 20 Jun 2007 14:15:16 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 085004050; Wed, 20 Jun 2007 14:15:11 -0400 (EDT) Date: Wed, 20 Jun 2007 14:15:11 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Performance query about large tables, lots of concurrent access Message-ID: <20070620181511.GC743@phlogiston.dyndns.org> References: <14291.1182221811@sss.pgh.pa.us> <4677B831.8060704@metacarta.com> <4677D298.2010109@metacarta.com> <20070619132643.GC4265@alvh.no-ip.org> <4677DC06.3000300@metacarta.com> <20070619134637.GG4265@alvh.no-ip.org> <467963A8.2060703@metacarta.com> <46796B7E.1040501@metacarta.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <46796B7E.1040501@metacarta.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/443 X-Sequence-Number: 25476 On Wed, Jun 20, 2007 at 02:01:34PM -0400, Karl Wright wrote: > (FWIW, ANALYZE operations are kicked off after every 30,000 inserts, > updates, or deletes, by the application itself). I don't think you should do it that way. I suspect that automatic VACUUM ANALYSE way more often on each table -- like maybe in a loop -- would be better for your case. A -- Andrew Sullivan | ajs@crankycanuck.ca In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland