Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 21CAE2E004C for ; Wed, 30 Apr 2008 04:25:34 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 72983-05 for ; Wed, 30 Apr 2008 04:25:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.229]) by developer.postgresql.org (Postfix) with ESMTP id 36CB32E0042 for ; Wed, 30 Apr 2008 04:25:31 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so229724rvf.43 for ; Wed, 30 Apr 2008 00:25:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=uXt5ZA+EAD/MLVr3qCKGpzG0Ns86blJr9o4MFYgVCSE=; b=WesBNvMc4SzhHNjsYqMckDMP8KjLKxUjdqITmBSHNZ4QAj74GeapftDWG+ZEUQK1jZYZvihh3Y0ou0tVDIL2+THgz7Q+WXaJa6KDGo69Ovf3eSne5hNUBHsNzA6AU1MMffeQqLKCDXhrcvdcXKlGqJND8+aI8RG5jz6dKc3qVWU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=llwKj2ehl8wmrZ7yk7pPDPGkmP7WwAM79dOkfaHTb/pPkY+iw2wq61nyJCE6EjH6CSaFNC6Defxdsqwf0/bvDbCC7FT/ccdr4W/LUsMgAr9LjHm6UJsnVdoIZV8Iwxv4XQlIEwoUheDQQusQuJc+z43ZiAVgF97kVHE6EGYmONw= Received: by 10.141.76.21 with SMTP id d21mr158256rvl.242.1209540330196; Wed, 30 Apr 2008 00:25:30 -0700 (PDT) Received: by 10.141.114.1 with HTTP; Wed, 30 Apr 2008 00:25:30 -0700 (PDT) Message-ID: <2e78013d0804300025j10567a82x5845ab8bc3d4f2a2@mail.gmail.com> Date: Wed, 30 Apr 2008 12:55:30 +0530 From: "Pavan Deolasee" To: "Gauri Kanekar" Subject: Re: Replication Syatem Cc: "Shane Ambler" , "Alvaro Herrera" , "Greg Smith" , pgsql-performance@postgresql.org In-Reply-To: <7e4ba9550804292346r46aa55e7g6cf1f731b6be7d40@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <7e4ba9550804280638ie81dc23w472785c83cd38fcf@mail.gmail.com> <7e4ba9550804290405i4c0d3a57x1640239c9995c13@mail.gmail.com> <20080429130204.GA5652@alvh.no-ip.org> <4817514A.3060704@Sheeky.Biz> <7e4ba9550804292229x82e74e5y355349866c72245c@mail.gmail.com> <2e78013d0804292237l4c74a166u4ab082901aa0804f@mail.gmail.com> <7e4ba9550804292239n668b1f01v59ad7ac6ca9e092b@mail.gmail.com> <2e78013d0804292343hd9d1c0lf93df68e559f9af3@mail.gmail.com> <7e4ba9550804292346r46aa55e7g6cf1f731b6be7d40@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/461 X-Sequence-Number: 29954 On Wed, Apr 30, 2008 at 12:16 PM, Gauri Kanekar wrote: > fillfactor is set to 80 as you suggested. > delta* fields r updated and these fields are no where related to any of the > index fields. > That's weird. With that fillfactor, you should have a very high percentage of HOT update ratio. It could be a very special case that we might be looking at. I think a self contained test case or a very detail explanation of the exact usage is what we need to explain this behavior. You may also try dropping non-critical indexes and test again. Btw, I haven't been able to reproduce this at my end. With the given indexes and kind of updates, I get very high percentage of HOT updates. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com