RT with postgresql

Hi all.

We installed RT 2.0.15 with postgresql. (RT and postgresql are on
different hosts). We are using mod_perl with apache 1.3.23.

We have now ~1500 tickets and RT is getting very very slow. Is it normal
? Are there anybody who is getting this ‘problem’ ?

Do you have any tips for tuning postgresql ?

Laurent

“LV” == Laurent Vaills laurent.vaills@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.

Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera@kciLink.com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

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.

Do you have any tips for mysql too?

Best regards,
David

“LV” == Laurent Vaills laurent.vaills@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

“DV” == David Vrtin david.vrtin@arnes.si writes:

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.

DV> Do you have any tips for mysql too?

Delete it and install postgres :wink:

Seriously, I gave up on mysql when i realized that the concurrency it
offered was insufficient for an application that did a lot of writes
from different processes to the same table.

DV> Do you have any tips for mysql too?

Delete it and install postgres :wink:

Seriously, I gave up on mysql when i realized that the concurrency it
offered was insufficient for an application that did a lot of writes
from different processes to the same table.

Did you ever try using innodb tables?