Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Hot Issue
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 4149 of 4424
Post > Topic >>

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]   2008-07-02 16:40:10 
Re: Hot Issue
tgl@[EMAIL PROTECTED] (T  2008-07-02 10:40:03 
Re: Hot Issue
meetgaurikanekar@[EMAIL P  2008-07-02 20:18:11 
Re: Hot Issue
tgl@[EMAIL PROTECTED] (T  2008-07-02 12:35:31 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 11:46:47 CST 2008.