[rt-devel] Postgres performance.

[Jeroen Ruigrok/asmodai]

It seems that every user you add adds about 120-160 msec (on my box)
to the query execution time for pgsql.

With 5 users I had:

950 msec
6 - 1070 msec
7 - 1230 msec

Going with Aidan's first optimisation reduces the latter result down to
about 250 msec, a whopping fifth of the original query.
While his second query reduces it to 106 msec, about a twelfth.

0.80.4 doesn't help with the ACL query when commenting on tickets.
It takes as long as the original, or perhaps a very small fraction less,
but still way too long.

-- 
Jeroen Ruigrok van der Werven <asmodai(at)wxs.nl> / asmodai / a capoeirista
PGP fingerprint: 2D92 980E 45FE 2C28 9DB7  9D88 97E6 839B 2EAC 625B
http://www.tendra.org/   | http://www.in-nomine.org/~asmodai/diary/
Only the wisest and the stupidest of men never change...