Skip site navigation (1) Skip section navigation (2)

Hot Issue

From: "Gauri Kanekar" <meetgaurikanekar(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Hot Issue
Date: 2008-07-02 12:31:23
Message-ID: 7e4ba9550807020531w5480956fs2a1b5b630babda41@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: Jonah H. HarrisDate: 2008-07-02 12:40:40
Subject: Re: Hot Issue
Previous:From: Jonah H. HarrisDate: 2008-07-02 11:41:49
Subject: Re: Fusion-io ioDrive

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group