[prev in list] [next in list] [prev in thread] [next in thread]
List: pgsql-performance
Subject: [PERFORM] Performance issues with postgresql-8.4.0
From: "Sachin Kumar" <Sachin.Ku () globallogic ! com>
Date: 2010-06-29 7:13:18
Message-ID: 21026437C2BC0D45BE196CB0A35EFEFD052700D7 () ex2-del1 ! synapse ! com
[Download RAW message or body]
Hi,
We are using postgresql-8.4.0 on 64-bit Linux machine (open-SUSE 11.x).
It's a master/slave deployment & slony-2.0.4.rc2 is used for DB
replication on the slave box.
At times we have observed that postgres stops responding for several
minutes, even couldn't fetch the number of entries in a particular
table. One such instance happens when we execute the following steps:
- Add few lakh entries (~20) to table X on the master DB.
- After addition, slony starts replication on the slave DB. It
takes several minutes (~25 mins) for replication to finish.
- During this time (while replication is in progress), sometimes
postgres stops responding, i.e. we couldn't even fetch the number of
entries in any table (X, Y, etc).
Can you please let us know what could the reason for such a behavior and
how it can be fixed/improved.
Regards,
Sachin
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:x="urn:schemas-microsoft-com:office:excel" \
xmlns:p="urn:schemas-microsoft-com:office:powerpoint" \
xmlns:a="urn:schemas-microsoft-com:office:access" \
xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" \
xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" \
xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" \
xmlns:b="urn:schemas-microsoft-com:office:publisher" \
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" \
xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" \
xmlns:odc="urn:schemas-microsoft-com:office:odc" \
xmlns:oa="urn:schemas-microsoft-com:office:activation" \
xmlns:html="http://www.w3.org/TR/REC-html40" \
xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" \
xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" \
xmlns:Repl="http://schemas.microsoft.com/repl/" \
xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" \
xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" \
xmlns:ppda="http://www.passport.com/NameSpace.xsd" \
xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" \
xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" \
xmlns:ds="http://www.w3.org/2000/09/xmldsig#" \
xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" \
xmlns:udc="http://schemas.microsoft.com/data/udc" \
xmlns:xsd="http://www.w3.org/2001/XMLSchema" \
xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" \
xmlns:ec="http://www.w3.org/2001/04/xmlenc#" \
xmlns:sp="http://schemas.microsoft.com/sharepoint/" \
xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" \
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" \
xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" \
xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" \
xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:st="" \
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Verdana;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1042556178;
mso-list-type:hybrid;
mso-list-template-ids:-1518288142 1475741498 67698691 67698693 67698689 67698691 \
67698693 67698689 67698691 67698693;} @list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:21.75pt;
mso-level-number-position:left;
margin-left:21.75pt;
text-indent:-.25in;
font-family:Verdana;
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
@list l0:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>We are using <b><span style='font-weight:
bold'>postgresql-8.4.0</span></b> on 64-bit Linux machine (open-SUSE 11.x).
It’s a master/slave deployment & slony-2.0.4.rc2 is used for DB
replication on the slave box.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>At times we have observed that <b><span
style='font-weight:bold'>postgres stops responding for several minutes</span></b>,
even couldn’t fetch the number of entries in a particular table. One such
instance happens when we execute the following steps:<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 \
lfo1'><![if !supportLists]><font size=2 color=blue face=Verdana><span \
style='font-size:10.0pt;font-family:Verdana; color:blue'><span \
style='mso-list:Ignore'>-<font size=1 face="Times New Roman"><span style='font:7.0pt \
"Times New Roman"'> \
</span></font></span></span></font><![endif]><font size=2 color=blue \
face=Verdana><span style='font-size:10.0pt;font-family:Verdana;color:blue'>Add few \
lakh entries (~20) to table X on the master DB.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 \
lfo1'><![if !supportLists]><font size=2 color=blue face=Verdana><span \
style='font-size:10.0pt;font-family:Verdana; color:blue'><span \
style='mso-list:Ignore'>-<font size=1 face="Times New Roman"><span style='font:7.0pt \
"Times New Roman"'> \
</span></font></span></span></font><![endif]><font size=2 color=blue \
face=Verdana><span style='font-size:10.0pt;font-family:Verdana;color:blue'>After \
addition, slony starts replication on the slave DB. It takes several minutes (~25 \
mins) for replication to finish.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:21.75pt;text-indent:-.25in;mso-list:l0 level1 \
lfo1'><![if !supportLists]><font size=2 color=blue face=Verdana><span \
style='font-size:10.0pt;font-family:Verdana; color:blue'><span \
style='mso-list:Ignore'>-<font size=1 face="Times New Roman"><span style='font:7.0pt \
"Times New Roman"'> \
</span></font></span></span></font><![endif]><font size=2 color=blue \
face=Verdana><span style='font-size:10.0pt;font-family:Verdana;color:blue'>During \
this time (while replication is in progress), sometimes <b><span \
style='font-weight:bold'>postgres stops responding</span></b>, i.e. we couldn’t \
even fetch the number of entries in any table (X, Y, \
etc).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>Can you please let us know what could
the reason for such a behavior and how it can be \
fixed/improved.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>Regards,</span></font><font color=blue><span
style='color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>Sachin</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic