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

[Alek Cesarz]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andrew J. Korty wrote, On 2003-12-11 13:29:

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

same issue here. but migrating to mysql did not help much. it looks as
it is not a matter of database, but more like perl DBD/DBI modules issue.
when i look at cpu util, i notice db taking ~50% for 10-20 seconds and
after that apache is going to the roof (97%) for next 10 minutes.

btw, can somebody send me a copy of purgedead.pl for RT2?

regards,
- -- 
Alek Cesarz : NOD manager : ALEK1-RIPE
+48 22 860 69 60 : Crowley Data Poland
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQE/2GSWC3s32xNJGmERAjgZAJ9ndggy3xFusKS0hNsVKe10K9bNKACgyNQJ
itXJX+iiRH/7vwqHbvW6mcU=
=4GgR
-----END PGP SIGNATURE-----