Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3B0F864FD64 for ; Wed, 2 Jul 2008 10:11:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 70119-07 for ; Wed, 2 Jul 2008 10:11:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182]) by postgresql.org (Postfix) with ESMTP id B0884650EB3 for ; Wed, 2 Jul 2008 10:11:40 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id n4so229327wag.5 for ; Wed, 02 Jul 2008 06:11:38 -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:references; bh=QNUPZlNX5qtCIJQjpCvOcPaKrsO5urGzSKTMWz5VUJo=; b=VTpRi7Deu1gVeQsNbXNfHbX9M0690HyailtgMppDfursqYD6zgJDiyMgB2/XS+XJ0u naNlaaqqbUSzv4QZDLOfmSsggGsRXIvIwIlLCIt2wvYL3ro5A3nYztDr2yUVgHvq5m65 bD3hPuyuuv6uG6L/oeX+P/8dP+91HTokE2tFU= 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:references; b=DQW+Cr7g8mdIEfxOvhzq9SuXiCqk17vs1hzGS514Cs7dGTdHeZU9Qt5f3Ym0nt2qAG ksgAsy99ScwLNFOEPg0gcmPe/6FrNeIYGmXQ0BggIJ0HsWzVnUaIhGBAw12Y1OofVlZP aQb0DNTiBAt2TBfySBzrx5zqxZWUUCEYys2ow= Received: by 10.114.156.1 with SMTP id d1mr6933989wae.171.1215004298372; Wed, 02 Jul 2008 06:11:38 -0700 (PDT) Received: by 10.115.60.2 with HTTP; Wed, 2 Jul 2008 06:11:38 -0700 (PDT) Message-ID: <7e4ba9550807020611x3dac7fffw8497d168c7a0e9d8@mail.gmail.com> Date: Wed, 2 Jul 2008 18:41:38 +0530 From: "Gauri Kanekar" To: "=?ISO-8859-1?Q?Devrim_G=DCND=DCZ?=" Subject: Re: Hot Issue Cc: pgsql-performance@postgresql.org In-Reply-To: <1215004084.2842.32.camel@laptop.gunduz.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2388_8608144.1215004298352" References: <7e4ba9550807020531w5480956fs2a1b5b630babda41@mail.gmail.com> <1215004084.2842.32.camel@laptop.gunduz.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.804 tagged_above=0 required=5 tests=AWL=0.803, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/22 X-Sequence-Number: 30622 ------=_Part_2388_8608144.1215004298352 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline How does it indicate if the entries qualify for hot update ?? hot have a limitation that it do not work if, the index column is updated. But that not the case over here. On Wed, Jul 2, 2008 at 6:38 PM, Devrim G=DCND=DCZ wrote= : > On Wed, 2008-07-02 at 18:01 +0530, Gauri Kanekar wrote: > > Checked out the performance of Hot on 30th June : > > > > relname n_tup_ins n_tup_upd n_tup_del > > n_tup_hot_upd > > n_live_tup n_dead_tup *table1* *15509156* *2884653* *0* *2442823* > > * > > 15509158* *68046* table2 434585 718472 0 642336 434703 16723 table3 > > 105546 > > 252143 0 233078 105402 4922 > > > > > Checked the performance of Hot on 2nd July : > > > > relname n_tup_ins n_tup_upd n_tup_del > > n_tup_hot_upd > > n_live_tup n_dead_tup *table1**15577724* *6237242* *0* *2924948* > > * > > 18460676* *131103* table2 435558 1579613 0 763397 1171497 42476 > > Maybe those updates were not qualified for HOT between these days? > > Regards, > -- > Devrim G=DCND=DCZ > devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr > http://www.gunduz.org > > --=20 Regards Gauri ------=_Part_2388_8608144.1215004298352 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
How does it indicate if the entries qualify for hot update ??

ho= t have a limitation that it do not work if, the index column is updated. Bu= t that not the case over here.

On= Wed, Jul 2, 2008 at 6:38 PM, Devrim G=DCND=DCZ <devrim@gunduz.org> wrote:

On Wed, 2008-07-02 at 18:01 +0530, Gauri Kanekar wrote:
> Checked out the performance of Hot on 30th June :
>
> relname = n_tup_ins n_tup_upd n_tup_del
> n_tup_hot_upd
> n_live_tup n_dead_tup *table1* *15509156* *2884653= * *0* *2442823*
> *
> 15509158* *68046* table2 434585 718472 0 642336 434703 16723 &nb= sp;table3
> 105546
> 252143 0 233078 105402 4922

<snip>

>
> Checked the performance of Hot on 2nd July :
>
> relname = n_tup_ins n_tup_upd n_tup_del
> n_tup_hot_upd
> n_live_tup n_dead_tup *table1**15577724* *6237242*= *0* *2924948*
> *
> 18460676* *131103* table2 435558 1579613 0 763397 1171497 42476<= br>

Maybe those updates were not qualified for HOT between these days?
Regards,
--
Devrim G=DCND=DCZ
devrim~gunduz.org, devr= im~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org

--
Regards
Gauri ------=_Part_2388_8608144.1215004298352--