[rt-users] postgres slowdowns? (pg 7.3.4, rt 3.0.4)
Jesse Vincent
jesse at bestpractical.com
Tue Sep 9 14:05:51 EDT 2003
On Tue, Sep 09, 2003 at 12:55:58PM -0400, Kevin Murphy wrote:
> Vivek,
>
> Thanks. Did I mention that a restart of postgres temporarily solves
> the problem? (Actually, I also restarted Apache at the same time, so I
> can't really say which is relevant.)
>
> >> are you by chance running a vacuum on your DB at the same time?
>
> No. However, ahem, I hadn't actually, er, vacuumed this database
> before. I just did it, and I will make this a cron job. Note,
> however, there was no perceptible improvement in performance after the
> 'vacuumdb --analyze rt3'. Probably because my database is still so
> small that full table scans are still practical (and the machine has
> 1.5 GB RAM, some of which the OS might use for disk caching? The
> machine is doing other things, but not very often, at the moment -- and
> not that I have seen during the slowdowns).
For kicks, you might want to try reverting to DBIx::SearchBuilder 0.90
to see if the change which fixed the postgres search-looping problem
introduced this performance issue.
Jesse
--
http://www.bestpractical.com/rt -- Trouble Ticketing. Free.
More information about the rt-users
mailing list