[rt-users] RT with postgresql

Laurent Vaills laurent.vaills at dms.at
Thu Mar 6 05:10:51 EST 2003


On Wed, 2003-03-05 at 18:52, Vivek Khera wrote:
> >>>>> "LV" == Laurent Vaills <laurent.vaills at dms.at> writes:
> 
> LV> Do you have any tips for tuning postgresql ?
> 
> 
> With the standard RT indexes it should be ok.
> 
> This assumes you do the normal postgres maintenance -- nightly "vacuum
> analyze" is recommended.  If you haven't done that in a looong time,
> then a "vacuum full analyze" is probably in order.
Thanks for the tip.

I tried that but RT is still slow. I put the vacuum in the crontab to be
run every hour.

Perhaps we will to wait some hours to see RT as fast as before.

Laurent

> 
> -- 
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Vivek Khera, Ph.D.                Khera Communications, Inc.
> Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
> AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/
> _______________________________________________
> 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





More information about the rt-users mailing list