| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pg(at)fastcrypt(dot)com, Josh Berkus <josh(at)agliodbs(dot)com>, Dirk_Lutzebäck <lutzeb(at)aeccom(dot)com>, ohp(at)pyrenet(dot)fr, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Joe Conway <mail(at)joeconway(dot)com>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-performance(at)postgresql(dot)org, Neil Conway <neilc(at)samurai(dot)com> |
| Subject: | Re: Wierd context-switching issue on Xeon |
| Date: | 2004-05-20 05:10:14 |
| Message-ID: | 1085029814.32765.10.camel@zedora2 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Wed, 2004-05-19 at 21:59, Robert Creager wrote:
> When grilled further on (Wed, 19 May 2004 21:20:20 -0400 (EDT)),
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> confessed:
>
> >
> > Did we ever come to a conclusion about excessive SMP context switching
> > under load?
> >
>
> 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. I've no idea why and
> didn't get a chance to investigate.
Strange. There is a known bug in the 7.4.2 version of pg_autovacuum
related to data type mismatches which is fixed in CVS. But that bug
doesn't cause pg_autovacuum to stop vacuuming but rather to vacuum to
often. So perhaps this is a different issue? Please let me know what
you find.
Thanks,
Matthew O'Connor
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Kirkwood | 2004-05-20 09:28:28 | Re: DB Design |
| Previous Message | Joseph Shraibman | 2004-05-20 04:49:43 | Re: PostgreSQL performance in simple queries |