[rt-users] performance problem - RT3.0.3 on Postgresql 7.3.3

[Sophie Rockhsar]

Hi Larry,

Using what I had from 3.0.2, I had tuned the "shared_buffers" parameter in the 
postgresql.conf file by setting it to 8192. Apart from that, what other 
tune-ups would you recommend? 

Thanks,
Sophie

On Thursday 26 June 2003 03:36 pm, Larry Rosenman wrote:
> have you tuned PostgreSQL?
>
> Mine seems(!) to be okay on a UnixWare box.
>
> BTW, Jesse or other devs, you guys are welcome to an account to test new
> versions etc on my box.
>
> LER
>
>
> --On Thursday, June 26, 2003 15:28:21 -0400 Sophie Rockhsar
>
> <sophia at aps.org> wrote:
> > Hi all,
> >
> > Just upgraded to RT 3.0.3, on PostgreSql 7.3.3 (FreeBSD 4.8 box). The
> > database  had already existed (and had RT 3.0.2 running on it), so I just
> > got the  upgrade through the ports collection, and left the existing
> > database intact.  I restarted the postgres server and apache, and that
> > was all...
> >
> > The performance of the database server is extremely bad when any
> > Reply/Resolve/Comment is issued on a ticket. Any suggestions?
> >
> > Thanks much,
> > Sophie
> > _______________________________________________
> > 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