Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id EBDF69FA134 for ; Tue, 19 Jun 2007 12:46:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 91577-01 for ; Tue, 19 Jun 2007 12:45:56 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147]) by postgresql.org (Postfix) with ESMTP id 55D6C9FA26D for ; Tue, 19 Jun 2007 12:45:56 -0300 (ADT) Received: by zoraida.natserv.net (Postfix, from userid 58) id 45001C2F6; Tue, 19 Jun 2007 11:45:55 -0400 (EDT) Received: from 35st.simplicato.com (static-71-249-233-130.nycmny.east.verizon.net [71.249.233.130]) by zoraida.natserv.net (Postfix) with ESMTP id BCD38C2AF; Tue, 19 Jun 2007 11:45:49 -0400 (EDT) References: <4676DD57.7070304@metacarta.com> <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> Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: Alvaro Herrera Cc: Karl Wright , Tom Lane , pgsql-performance@postgresql.org Subject: Re: Performance query about large tables, lots of concurrent access Date: Tue, 19 Jun 2007 11:45:49 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="US-ASCII" Content-Disposition: inline Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.289 tagged_above=0 required=5 tests=AWL=0.153, BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200706/355 X-Sequence-Number: 25388 Alvaro Herrera writes: > How large is the database? I must admit I have never seen a database > that took 4 days to vacuum. This could mean that your database is > humongous, or that the vacuum strategy is wrong for some reason. Specially with 16GB of RAM. I have a setup with several databases (the largest of which is 1TB database) and I do a nightly vacuum analyze for ALL databases. It takes about 22 hours. And this is with constant updates to the large 1TB database. This is with Postgresql 8.1.3