<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [rt-users] postgres slowdowns? (pg 7.3.4, rt 3.0.4)</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>The thing to remember is that Postgresql's settings are extremely conservative, i.e. low, to start with. The rationale is that they want anyone to be able to get postgresql at least running immediately, even on very limited hardware.</FONT></P>
<P><FONT SIZE=2>I know shared_buffers is one of the main variables you'll want to increase dramatically; I would search for that on the postgresql users mailing list; the subject has been discussed extensively there. </FONT></P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Wes Sheldahl</FONT>
<BR><FONT SIZE=2>iHigh NetOps </FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Les Mikesell [<A HREF="mailto:les@futuresource.com">mailto:les@futuresource.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, September 11, 2003 1:25 PM</FONT>
<BR><FONT SIZE=2>To: Vivek Khera</FONT>
<BR><FONT SIZE=2>Cc: rt-users@lists.fsck.com</FONT>
<BR><FONT SIZE=2>Subject: Re: [rt-users] postgres slowdowns? (pg 7.3.4, rt 3.0.4)</FONT>
</P>
<BR>
<P><FONT SIZE=2>On Tue, 2003-09-09 at 11:01, Vivek Khera wrote:</FONT>
</P>
<P><FONT SIZE=2>> are you by chance running a vacuum on your DB at the same time?</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> have you tuned your PG beyond the defaults for amount of shared memory</FONT>
<BR><FONT SIZE=2>> and sort memory?</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> what is the concurrency of use at the slow times?</FONT>
</P>
<P><FONT SIZE=2>I just copied over about 12,000 tickets from a fairly snappy</FONT>
<BR><FONT SIZE=2>rt2/mysql to a different machine with rt3/postgresql and it</FONT>
<BR><FONT SIZE=2>is extremely slow even with just one user. I've done a</FONT>
<BR><FONT SIZE=2>vacuum analyze but am still running with the default postmaster</FONT>
<BR><FONT SIZE=2>settings from a RedHat RPM install. Can you suggest some</FONT>
<BR><FONT SIZE=2>options to speed it up? The machine has a gig of ram (the other</FONT>
<BR><FONT SIZE=2>one had 2 gigs) but I can add more if needed.</FONT>
</P>
<P><FONT SIZE=2>---</FONT>
<BR><FONT SIZE=2> Les Mikesell</FONT>
<BR><FONT SIZE=2> les@futuresource.com</FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>rt-users mailing list</FONT>
<BR><FONT SIZE=2>rt-users@lists.fsck.com</FONT>
<BR><FONT SIZE=2><A HREF="http://lists.fsck.com/mailman/listinfo/rt-users" TARGET="_blank">http://lists.fsck.com/mailman/listinfo/rt-users</A></FONT>
</P>
<P><FONT SIZE=2>Have you read the FAQ? The RT FAQ Manager lives at <A HREF="http://fsck.com/rtfm" TARGET="_blank">http://fsck.com/rtfm</A></FONT>
</P>
</BODY>
</HTML>