Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B8B7B64FE0F for ; Wed, 2 Jul 2008 09:31:36 -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 39991-02 for ; Wed, 2 Jul 2008 09:31:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id D976A650E8A for ; Wed, 2 Jul 2008 09:31:30 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id d37so175728pye.29 for ; Wed, 02 Jul 2008 05:31:28 -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:mime-version:content-type; bh=l6a9khJIF5N90Gdl3ZQa0yB0EYX/3WPACeHZicCh21M=; b=f6TS6UNNnnyaFAb1Tp+BTr6cT24yXaMm6zcUrLLjTxT865fJvgsmDv0JsnR/IqrhDo BryJZnhS4Y6T0CCphR4LgIJasfGm8LWv7iZS7UYP0+Xo4Xn9oxlqPDCLG9WgH686I370 uDHE7Qa3ENFJN4RSh0urmI8wjSXDtM/DxnnBQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=I50lt3B+xeV61U3LQTzVkfybfuEbq3awJ+VgauZFr9b8GDy08dN3vdUDhZiud+dbwR ip9jUvfVK+AJeC/dRlBHGtfkwu/fuvaL6ba4IIdagjTGWs/WyVu63eMNVaKVGKgBAv0E ddIJuLjy079CSftrYsf4vqLOV4CiKumMKIQBc= Received: by 10.115.59.2 with SMTP id m2mr6884241wak.197.1215001888313; Wed, 02 Jul 2008 05:31:28 -0700 (PDT) Received: by 10.115.60.2 with HTTP; Wed, 2 Jul 2008 05:31:23 -0700 (PDT) Message-ID: <7e4ba9550807020531w5480956fs2a1b5b630babda41@mail.gmail.com> Date: Wed, 2 Jul 2008 18:01:23 +0530 From: "Gauri Kanekar" To: pgsql-performance@postgresql.org Subject: Hot Issue MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_2189_33309263.1215001883272" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.072 tagged_above=0 required=5 tests=AWL=0.071, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200807/18 X-Sequence-Number: 30618 ------=_Part_2189_33309263.1215001883272 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all, We have upgraded our database server to postgres 8.3.1 on 28th June. 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 table4 7303628 96098 176790 23445 7126838 3443 table5 11117045 22245 0 16910 11117045 440 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 table3 105814 540997 0 273443 355287 14184 table4 7614752 219329 513268 41053 7424721 62 table5 11184309 47665 0 21198 11206296 745 Performance of Hot was much better on 30June as compared to 2nd July. Can anybody , help out over here. ~ Gauri relname n_tup_ins n_tup_upd n_tup_del n_tup_hot_upd n_live_tup n_dead_tup -- Regards Gauri ------=_Part_2189_33309263.1215001883272 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi all,

We have upgraded our database server to postgres 8.3.1 on 28th June.

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
table4 7303628 96098 176790 23445 7126838 3443
table5 11117045 22245 0 16910 11117045 440


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 
table115577724 6237242 0 2924948 18460676 131103
table2 435558 1579613 0 763397 1171497 42476
table3 105814 540997 0 273443 355287 14184
table4 7614752 219329 513268 41053 7424721 62
table5 11184309 47665 0 21198 11206296 745



































Performance of Hot was much better on 30June as compared to 2nd July.

Can anybody , help out over here.

~ Gauri
relname            
 n_tup_ins 
 n_tup_upd 
 n_tup_del 
 n_tup_hot_upd 
 n_live_tup 
 n_dead_tup 


--
Regards
Gauri ------=_Part_2189_33309263.1215001883272--