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
