[rt-users] Performance on PostgreSQL
jesse at bestpractical.com
Fri Oct 13 00:27:02 EDT 2006
On Fri, Oct 13, 2006 at 12:22:36AM -0400, Kevin White wrote:
> Jesse Vincent wrote:
> >On Thu, Oct 12, 2006 at 11:51:52PM -0400, Kevin White wrote:
> >>The production server is running Centos 4 (RHEL 4) on a machine that
> >>really doesn't have enough RAM (1GB) and only has IDE disks, running as
> >>a software RAID1. It IS an Opteron, and it is running 64-bit. rt 3.4.1
> >>and postgresql 8.0.3.
> >Strongly recommend:
> > * newer RT
> > * newer Pg (8.x before 8.1.4 had some specialness)
> > * vacuum analyzing your postgres instance.
> Thanks Jesse...when you say newer RT, do you mean newer than 3.4.5?
I recall that we made a major pg-related fix around 3.4.2 or so. If you
suspect it's postgres-side stuff that's slowing you down, turning on the
query log and seeing if you can reindex a bit is worthwhile.
> My test box has Pg 8.1.4, and my next step will be attempting to take
> that to RT 3.4.5, then 3.6.1 (.2 by then, probably). I have some small
> customizations I need to carry forward.
> I do vacuum analyze, 3 times a day actually, so I do that. :)
> Thanks for the advice. If I find anything else, I'll post (and
> contribute to the Wiki).
More information about the RT-Users