Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3F8B09FB29A for ; Thu, 2 Nov 2006 11:15:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 26398-02 for ; Thu, 2 Nov 2006 11:15:33 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id 196D59FA432 for ; Thu, 2 Nov 2006 11:15:32 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id g2so1177701nfe for ; Thu, 02 Nov 2006 07:15:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=FkFEkfANUSoP3H1Fd4K+QWjifEwSUVUV6xkJ1G9/qUifHOlACE1hDz/BKUNc5Dx6ApqY4RF9od5QMvGh2OEr1zgc4N/PpJd9m4FWLYOMjYiXerXhfrP5BNOroI5r3b0CE123ifiKj87p1fRSgv7BE2X8kSbrCCRfyUhKoKdYPDY= Received: by 10.49.20.15 with SMTP id x15mr4731100nfi.1162480530631; Thu, 02 Nov 2006 07:15:30 -0800 (PST) Received: by 10.70.102.8 with HTTP; Thu, 2 Nov 2006 07:15:30 -0800 (PST) Message-ID: <357fa7590611020715k66ba3ba0r28c5f4511589909d@mail.gmail.com> Date: Thu, 2 Nov 2006 10:15:30 -0500 From: "Steven Flatt" To: "Simon Riggs" Subject: Re: Database-wide vacuum can take a long time, duringwhich tables are not being analyzed Cc: pgsql-performance@postgresql.org In-Reply-To: <1162464559.3587.291.camel@silverbirch.site> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5424_1624114.1162480530219" References: <357fa7590611011115q748ddce9qa6cf570ec2f15348@mail.gmail.com> <1162464559.3587.291.camel@silverbirch.site> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/25 X-Sequence-Number: 21795 ------=_Part_5424_1624114.1162480530219 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Sorry, I think there's a misunderstanding here. Our system is not doing near that number of transactions per second. I meant that the duration of a single DB-wide vacuum takes on the order of a couple of weeks. The time between DB-wide vacuums is a little over a year, I believe. > Every couple of weeks implies a transaction rate of ~~500tps, so I'd be > interested to hear more about your system. > > -- > Simon Riggs > EnterpriseDB http://www.enterprisedb.com > > > ------=_Part_5424_1624114.1162480530219 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Sorry, I think there's a misunderstanding here.  Our system is not doing near that number of transactions per second.  I meant that the duration of a single DB-wide vacuum takes on the order of a couple of weeks.  The time between DB-wide vacuums is a little over a year, I believe.
 
 
Every couple of weeks implies a transaction rate of ~~500tps, so I'd be
interested to hear more about your system.

--
Simon Riggs
EnterpriseDB   http://www.enterprisedb.com



------=_Part_5424_1624114.1162480530219--