SLOW: Home -> Search in 5-6 seconds?

RT Users
1

Howdy!

RT using Postgres on Linux is moving very slowly; I can regularly
reproduce the following sequence in a DB with < 150 tickets.

2

“JM” == Jim Meyer purp@wildbrain.com writes:

JM> I saw this when I had the webserver and database server on two different
JM> machines; I continue to see it with the both on the same machine (a 550
JM> MHz Pentium III with 256M RAM)

Get faster disks and allocate more resources for Postgres (shared
memory segments, and also tell postgres to use more in postgres.conf).

3

Get faster disks and allocate more resources for Postgres (shared
memory segments, and also tell postgres to use more in postgres.conf).

Thanks for making me look at Postgres tuning before system tuning; it
turns out that one of our guys had config’d the Postgresql server to
maximum debug, maximum noisy, and maximum syslog level. Pretty much
every word of every conversation between the webserver and the database
server was being logged.

I’ve toned that down a bit and things are much, MUCH zippier now.

Thanks again!

–j
Jim Meyer, Geek At Large purp@wildbrain.com