Re: Wierd context-switching issue on Xeon
Robert Creager <robert_creager@logicalchaos.org>
From: Robert Creager <Robert_Creager@LogicalChaos.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, pg@fastcrypt.com, Josh Berkus <josh@agliodbs.com>, Dirk_Lutzebäck <lutzeb@aeccom.com>, ohp@pyrenet.fr, Joe Conway <mail@joeconway.com>, "scott.marlowe" <scott.marlowe@ihs.com>, pgsql-performance@postgresql.org, Neil Conway <neilc@samurai.com>
Date: 2004-05-20T02:59:21Z
Lists: pgsql-performance
When grilled further on (Wed, 19 May 2004 22:42:26 -0400), Tom Lane <tgl@sss.pgh.pa.us> confessed: > Robert Creager <Robert_Creager@LogicalChaos.org> writes: > > I just figured out what was causing the problem on my system Monday. > > I'm using the pg_autovacuum daemon, and it was not vacuuming my db. > > Do you have the post-7.4.2 datatype fixes for pg_autovacuum? No. I'm still running 7.4.1 w/associated contrib. I guess an upgrade is in order then. I'm currently downloading 7.4.2 to see what the change is that I need. Is it just the 7.4.2 pg_autovacuum that is needed here? I've caught a whiff that 7.4.3 is nearing release? Any idea when? Thanks, Rob -- 20:45:52 up 21 days, 3:30, 4 users, load average: 2.02, 2.05, 2.05 Linux 2.6.5-01 #7 SMP Fri Apr 16 22:45:31 MDT 2004