Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 7171E9F944C for ; Sun, 23 Sep 2007 14:27:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 74998-05 for ; Sun, 23 Sep 2007 14:27:46 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id D73A49F93A2 for ; Sun, 23 Sep 2007 14:27:46 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l8NHRZNA021429; Sun, 23 Sep 2007 13:27:35 -0400 (EDT) To: "Jonah H. Harris" cc: "Carlos Moreno" , pgsql-performance@postgresql.org Subject: Re: Possible explanations for catastrophic performace deterioration? In-reply-to: <36e682920709230956p1312745eif1c6ba7a342dae3d@mail.gmail.com> References: <46F6981B.1010600@mochima.com> <36e682920709230956p1312745eif1c6ba7a342dae3d@mail.gmail.com> Comments: In-reply-to "Jonah H. Harris" message dated "Sun, 23 Sep 2007 12:56:35 -0400" Date: Sun, 23 Sep 2007 13:27:35 -0400 Message-ID: <21428.1190568455@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/401 X-Sequence-Number: 26946 "Jonah H. Harris" writes: > My guess is that a vacuum full would've brought the other database > back up to speed. Yeah, table bloat is what it sounds like to me too. > In the future, you probably want to set fillfactor > to a reasonable amount to account for updates-to-blocks-between-vacuum > to try and capture as few row-migrations as possible. More to the point, check your FSM size and make sure vacuums are happening often enough. regards, tom lane