Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id D0ACE2E0041 for ; Wed, 30 Apr 2008 03:43:15 -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 60634-10 for ; Wed, 30 Apr 2008 03:43:10 -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.237]) by developer.postgresql.org (Postfix) with ESMTP id 6A7082E003B for ; Wed, 30 Apr 2008 03:43:12 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so222611rvf.43 for ; Tue, 29 Apr 2008 23:43:11 -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=E8+UBKNAoecNKiErGkRET3x/O68yRiQouE653Yx7fnI=; b=PgDdAKaS76ytkFgffcukOmK3SneeGTUY1SfABY6tj/LgZ/+DhcQewcx0C692AYmrb4hsd3d3FmjtR2cTJdncGjijmWq+YLMO5ZfQXNWyIgxsRlMLc4q6X7/RMxGNZ5MW5wMojsFo8NJNz2i2ENdL8xggK/WnjF9XsycEfxX6q8Y= 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=QGv//118POHR7o6HfFI0BitphsXfzI7P8d6bzj86mXLzYQL3ng9nlj5j1MCYRMshxMDDhV2i0K8y1eM7eal/pyFnzlF6sVy1Tsuf3VK7y9omp5R3bRQOdpmgv/PPbQeCobsFxOQAaxT9qh/6mjAYZErGGoTksWADqb0nJdOfydA= Received: by 10.140.165.21 with SMTP id n21mr143650rve.257.1209537791438; Tue, 29 Apr 2008 23:43:11 -0700 (PDT) Received: by 10.141.114.1 with HTTP; Tue, 29 Apr 2008 23:43:11 -0700 (PDT) Message-ID: <2e78013d0804292343hd9d1c0lf93df68e559f9af3@mail.gmail.com> Date: Wed, 30 Apr 2008 12:13:11 +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: <7e4ba9550804292239n668b1f01v59ad7ac6ca9e092b@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> <20080428162243.GN2970@commandprompt.com> <7e4ba9550804282246p73c62fc6y5e7cb7dda55a6b50@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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/459 X-Sequence-Number: 29952 On Wed, Apr 30, 2008 at 11:09 AM, Gauri Kanekar wrote: > relid | relname | n_tup_ins | n_tup_upd | n_tup_hot_upd | n_dead_tup > -------+----------------+-----------+-----------+---------------+------------ > 16461 | table1 | 0 | 8352496 | 5389 | 8351242 > Hmm.. So indeed there are very few HOT updates. What is the fillfactor you are using for these tests ? If its much less than 100, the very low percentage of HOT updates would make me guess that you are updating one of the index columns. Otherwise at least the initial updates until you fill up the free space should be HOT. Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com