[rt-users] PostgreSQL and RT

[freebsd at coal.sentex.ca]

We've got an RT instance that is starting to grow, and is getting
harder and harder on the system.  We've seen PostgreSQL use 20-25% of
CPU, with multiple instances running.

I guess a first question: does RT support connection pooling, or can
it use Unix-style sockets (instead of TCP/IP sockets) with PostgreSQL?
It looks like it can with MySQL, though I may be mistaken.

Secondly, does anyone have any pointers to postgres tuning?  I think
I've got it pretty well configured, just looking for someone to
compare configurations to.  The most I can think of is to up our
SHMMAXPGS (we're running FreeBSD), but I'm afraid of locking down too
much RAM.

The current system is a PIII-1GHz, with 756MB RAM.  When busy, the
load can easly hit 2.00, but usually sits around 0.30.  We
continuously see processes blocking (but that may be something else
going on), and there is little to no paging at all.

TIA.