[rt-users] PostgreSQL and RT

[Vivek Khera]

>>>>> "f" == freebsd  <freebsd at coal.sentex.ca> writes:

f> compare configurations to.  The most I can think of is to up our
f> SHMMAXPGS (we're running FreeBSD), but I'm afraid of locking down too
f> much RAM.

You also need to bump up the SHM that postgres uses.  The defaults are
pretty bad for any large database.  Try with 25% of your RAM for SHM,
and tell freebsd to use SHM directly -- not thru the VM system.
There's a sysctl for that.

Also, you need to ensure that you "vacuum analyze" your tables
regularly.  I do my RT tables nightly.