[rt-users] postgres slowdowns? (pg 7.3.4, rt 3.0.4)

[wesley.sheldahl at ihigh.com]

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.

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. 

-- 
Wes Sheldahl
iHigh NetOps 

-----Original Message-----
From: Les Mikesell [mailto:les at futuresource.com]
Sent: Thursday, September 11, 2003 1:25 PM
To: Vivek Khera
Cc: rt-users at lists.fsck.com
Subject: Re: [rt-users] postgres slowdowns? (pg 7.3.4, rt 3.0.4)


On Tue, 2003-09-09 at 11:01, Vivek Khera wrote:

> are you by chance running a vacuum on your DB at the same time?
> 
> have you tuned your PG beyond the defaults for amount of shared memory
> and sort memory?
> 
> what is the concurrency of use at the slow times?

I just copied over about 12,000 tickets from a fairly snappy
rt2/mysql to a different machine with rt3/postgresql and it
is extremely slow even with just one user.  I've done a
vacuum analyze but am still running with the default postmaster
settings from a RedHat RPM install.   Can you suggest some
options to speed it up?  The machine has a gig of ram (the other
one had 2 gigs) but I can add more if needed.

---
   Les Mikesell
    les at futuresource.com

_______________________________________________
rt-users mailing list
rt-users at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20030911/cc250d97/attachment.htm>