Hot Issue

["Gauri Kanekar" <meetgaurikanekar@xxxxxxxxx>]

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