Hot Issue

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