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

[Andrew J. Korty]

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

Alek Cesarz <acesarz at crowley.pl> writes:

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

I haven't seen that behavior, and MySQL is generally faster for us.
But searching attachment content is still unusably slow.  I'm guessing
it doesn't help that we're not using any indexing on the attachment
content and that we're treating all attachments the same.  So if
someone sends us a big binary file, we're searching it every time.

- -- 
Andrew J. Korty, Principal Security Engineer, GCIA, GCFA
Office of the Vice President for Information Technology
Indiana University
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/2GbV8gM8+Mr5peERAp9aAKDX4S220I7A3/mvLsbBDkbs9LxVbQCguCzL
Sw1moQXVgTG242aP8DHhst8=
=LKky
-----END PGP SIGNATURE-----