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
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
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?