[rt-users] postgres slowdowns? (pg 7.3.4, rt 3.0.4)

[Jesse Vincent]

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.