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

[Vivek Khera]

>>>>> "LM" == Les Mikesell <les at futuresource.com> writes:

LM> vacuum analyze but am still running with the default postmaster
LM> settings from a RedHat RPM install.   Can you suggest some
LM> options to speed it up?  The machine has a gig of ram (the other
LM> one had 2 gigs) but I can add more if needed.

Well, the default postgres install isn't gonna use anywhere near the
ram you've got.  definitely boost your shared buffers settings to
something around 1000 or 2000, and increase sort_mem to at least 8192.

Also, the latest DBIx::SearchBuilder may have performance issues.  I'm
about to do the migration from rt2 to rt3 on postgres, so i'll have
more experience then.