Hot Issue

by meetgaurikanekar@[EMAIL PROTECTED] ("Gauri Kanekar") Jul 2, 2008 at 06:01 PM
------=_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,<br><br>We have upgraded our database server to postgres 8.3.1 on
28th June.<br><br>Checked out the performance of Hot on 30th June
:<br><br>
 <table style="border-collapse: collapse; width: 554pt;" border="0"
cellpadding="0" cellspacing="0" width="738"><col style="width: 149pt;"
width="199">
 <col style="width: 104pt;" width="138">
 <col style="width: 56pt;" width="75">
 <col style="width: 53pt;" width="71">
 <col style="width: 76pt;" width="101">
 <col style="width: 54pt;" width="72">
 <col style="width: 62pt;" width="82">
 <tbody><tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt; width: 149pt;" height="17"
width="199">relname<span
style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></td>
  <td style="width: 104pt;" width="138"><span
style="">&nbsp;</span>n_tup_ins<span style="">&nbsp;</span></td>
  <td style="width: 56pt;" width="75"><span
style="">&nbsp;</span>n_tup_upd<span style="">&nbsp;</span></td>
  <td style="width: 53pt;" width="71"><span
style="">&nbsp;</span>n_tup_del<span style="">&nbsp;</span></td>
  <td style="width: 76pt;" width="101"><span
style="">&nbsp;</span>n_tup_hot_upd<span style="">&nbsp;</span></td>
  <td style="width: 54pt;" width="72"><span
style="">&nbsp;</span>n_live_tup<span style="">&nbsp;</span></td>
  <td style="width: 62pt;" width="82"><span
style="">&nbsp;</span>n_dead_tup<span style="">&nbsp;</span></td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt;" height="17"><b>table1</b></td>
  <td align="right"><b>15509156</b></td>
  <td align="right"><b>2884653</b></td>
  <td align="right"><b>0</b></td>
  <td align="right"><b>2442823</b></td>
  <td align="right"><b>15509158</b></td>
  <td align="right"><b>68046</b></td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt;" height="17">table2</td>
  <td align="right">434585</td>
  <td align="right">718472</td>
  <td align="right">0</td>
  <td align="right">642336</td>
  <td align="right">434703</td>
  <td align="right">16723</td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt;" height="17">table3</td>
  <td align="right">105546</td>
  <td align="right">252143</td>
  <td align="right">0</td>
  <td align="right">233078</td>
  <td align="right">105402</td>
  <td align="right">4922</td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt;" height="17">table4</td>
  <td align="right">7303628</td>
  <td align="right">96098</td>
  <td align="right">176790</td>
  <td align="right">23445</td>
  <td align="right">7126838</td>
  <td align="right">3443</td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt;" height="17">table5</td>
  <td align="right">11117045</td>
  <td align="right">22245</td>
  <td align="right">0</td>
  <td align="right">16910</td>
  <td align="right">11117045</td>
  <td align="right">440</td>
 </tr>
</tbody></table><br><br>Checked the performance of Hot on 2nd July
:<br><br>
 <table style="border-collapse: collapse; width: 554pt;" border="0"
cellpadding="0" cellspacing="0" width="738"><col style="width: 149pt;"
width="199">
 <col style="width: 104pt;" width="138">
 <col style="width: 56pt;" width="75">
 <col style="width: 53pt;" width="71">
 <col style="width: 76pt;" width="101">
 <col style="width: 54pt;" width="72">
 <col style="width: 62pt;" width="82">
 <tbody><tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt; width: 149pt;" height="17"
width="199">relname<span
style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></td>
  <td style="width: 104pt;" width="138"><span
style="">&nbsp;</span>n_tup_ins<span style="">&nbsp;</span></td>
  <td style="width: 56pt;" width="75"><span
style="">&nbsp;</span>n_tup_upd<span style="">&nbsp;</span></td>
  <td style="width: 53pt;" width="71"><span
style="">&nbsp;</span>n_tup_del<span style="">&nbsp;</span></td>
  <td style="width: 76pt;" width="101"><span
style="">&nbsp;</span>n_tup_hot_upd<span style="">&nbsp;</span></td>
  <td style="width: 54pt;" width="72"><span
style="">&nbsp;</span>n_live_tup<span style="">&nbsp;</span></td>
  <td style="width: 62pt;" width="82"><span
style="">&nbsp;</span>n_dead_tup<span style="">&nbsp;</span></td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt;" height="17"><b>table1</b></td><td
align="right"><b>15577724</b></td>
  <td align="right"><b>6237242</b></td>
  <td align="right"><b>0</b></td>
  <td align="right"><b>2924948</b></td>
  <td align="right"><b>18460676</b></td>
  <td align="right"><b>131103</b></td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt;" height="17">table2</td>
  <td align="right">435558</td>
  <td align="right">1579613</td>
  <td align="right">0</td>
  <td align="right">763397</td>
  <td align="right">1171497</td>
  <td align="right">42476</td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt;" height="17">table3</td>
  <td align="right">105814</td>
  <td align="right">540997</td>
  <td align="right">0</td>
  <td align="right">273443</td>
  <td align="right">355287</td>
  <td align="right">14184</td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt;" height="17">table4</td>
  <td align="right">7614752</td>
  <td align="right">219329</td>
  <td align="right">513268</td>
  <td align="right">41053</td>
  <td align="right">7424721</td>
  <td align="right">62</td>
 </tr>
 <tr style="height: 12.75pt;" height="17">
  <td style="height: 12.75pt;" height="17">table5</td>
  <td align="right">11184309</td>
  <td align="right">47665</td>
  <td align="right">0</td>
  <td align="right">21198</td>
  <td align="right">11206296</td>
  <td align="right">745</td>
 </tr>
</tbody></table>
 <table style="border-collapse: collapse;" border="0" cellpadding="0"
cellspacing="0" height="133" width="1"><col style="width: 149pt;"
width="199"><tbody><tr><td valign="top"><br></td><td
valign="top"><br></td><td valign="top">
<br></td><td valign="top"><br></td><td valign="top"><br></td></tr><tr
style="height: 12.75pt;" height="17"><td style="width: 56pt;"
width="75"><br></td><td style="width: 53pt;" width="71"><br></td><td
style="width: 76pt;" width="101">
<br></td><td style="width: 54pt;" width="72"><br></td><td style="width:
62pt;" width="82"><br></td></tr><tr style="height: 12.75pt;"
height="17"><td align="right"><br></td><td align="right"><br></td><td
align="right"><br>
</td><td align="right"><br></td><td align="right"><br></td></tr><tr
style="height: 12.75pt;" height="17"><td align="right"><br></td><td
align="right"><br></td><td align="right"><br></td><td
align="right"><br></td><td align="right">
<br></td></tr><tr style="height: 12.75pt;" height="17"><td
align="right"><br></td><td align="right"><br></td><td
align="right"><br></td><td align="right"><br></td><td
align="right"><br></td></tr><tr style="height: 12.75pt;" height="17">
<td align="right"><br></td><td align="right"><br></td><td
align="right"><br></td><td align="right"><br></td><td
align="right"><br></td></tr><tr style="height: 12.75pt;" height="17"><td
align="right"><br></td><td align="right">
<br></td><td align="right"><br></td><td align="right"><br></td><td
align="right"><br></td></tr></tbody></table>Performance of Hot was much
better on 30June as compared to 2nd July.<br><br>Can anybody , help out
over here.<br>
<br>~ Gauri<br><table style="border-collapse: collapse; width: 554pt;"
border="0" cellpadding="0" cellspacing="0" width="738"><col style="width:
149pt;" width="199"><col>
  <tbody><tr><td style="height: 12.75pt; width: 149pt;" height="17"
width="199">relname<span
style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><br></td>
  <td style="width: 104pt;" width="138"><span
style="">&nbsp;</span>n_tup_ins<span style="">&nbsp;</span><br></td>
  <td style="width: 56pt;" width="75"><span
style="">&nbsp;</span>n_tup_upd<span style="">&nbsp;</span><br></td>
  <td style="width: 53pt;" width="71"><span
style="">&nbsp;</span>n_tup_del<span style="">&nbsp;</span><br></td>
  <td style="width: 76pt;" width="101"><span
style="">&nbsp;</span>n_tup_hot_upd<span style="">&nbsp;</span><br></td>
  <td style="width: 54pt;" width="72"><span
style="">&nbsp;</span>n_live_tup<span style="">&nbsp;</span><br></td>
  <td style="width: 62pt;" width="82"><span
style="">&nbsp;</span>n_dead_tup<span style="">&nbsp;</span><br></td>
</tr></tbody><col style="width: 104pt;" width="138"><col style="width:
56pt;" width="75"><col style="width: 53pt;" width="71"><col style="width:
76pt;" width="101"><col style="width: 54pt;" width="72"><col style="width:
62pt;" width="82"><tbody><tr style="height: 12.75pt;" height="17">
</tr></tbody></table><br clear="all"><br>-- <br>Regards<br>Gauri

------=_Part_2189_33309263.1215001883272--
7 Posts in Topic:
Hot Issue
meetgaurikanekar@[EMAIL P
2008-07-02 18:01:23
Re: Hot Issue
jonah.harris@[EMAIL PROTE
2008-07-02 08:40:40
Re: Hot Issue
meetgaurikanekar@[EMAIL P
2008-07-02 18:11:43
Re: Hot Issue
devrim@[EMAIL PROTECTED]