[rt-users] Re: Does Postgres offer acceptable performance

[Andrew J. Korty]

Richard Gration <richard at zync.co.uk> writes:

> On Thursday 11 December 2003 12:29, Andrew J. Korty wrote:
>
>> I'm a long-time PostgreSQL user, but it was intolerably slow with a
>> 30,000-ticket RT database.  Even after a *lot* of tuning (server
>> parameters, custom indexes, etc.), certain queries, especially large
>> joins, took minutes to complete.  Other folks seem to have no
>> problems, though, so maybe I missed something.
>
> At the risk of stating the obvious (a subject which all English
> people have a doctorate in ;-) ), how long has it been since you did
> a "vacuum analyze" on your rt db? I have seen this simple operation
> cut down the time for big joins from a couple of minutes to a couple
> of seconds!!

I was doing "vacuum analyze" several times a day, and it did improve
performance.  It just didn't improve it enough. :-)

-- 
Andrew J. Korty, Principal Security Engineer, GCIA, GCFA
Office of the Vice President for Information Technology
Indiana University