Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: performance problems ... 100 cpu utilization
- From: Dennis <dennis(at)works4me(dot)com>
- To: David Mitchell <david(dot)mitchell(at)telogis(dot)com>
- Cc: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: performance problems ... 100 cpu utilization
- Date: Wed, 13 Jul 2005 23:54:38 -0700
- Message-id: <42D60C2E.3020004@works4me.com> <text/plain>
David Mitchell wrote:
What is the load average on this machine? Do you do many updates? If you do a lot of updates, perhaps you haven't vacuumed recently. We were seeing similar symptoms when we started load testing our stuff and it turned out we were vacuuming too infrequently.
The load average at the 100% utilization point was about 30! A vacuum analyze was done before the test was started. I believe there are many more selects than updates happening at any one time.
Dennis
- Follow-Ups:
- Re: performance problems ... 100 cpu utilization
- From: David Mitchell
- Re: performance problems ... 100 cpu utilization
- References:
- performance problems ... 100 cpu utilization
- From: Dennis
- Re: performance problems ... 100 cpu utilization
- From: Qingqing Zhou
- Re: performance problems ... 100 cpu utilization
- From: Dennis
- Re: performance problems ... 100 cpu utilization
- From: David Mitchell
- performance problems ... 100 cpu utilization
- Prev by Date: JFS fastest filesystem for PostgreSQL?
- Next by Date: Re: JFS fastest filesystem for PostgreSQL?
- Previous by thread: Re: performance problems ... 100 cpu utilization
- Next by thread: Re: performance problems ... 100 cpu utilization
- Indexes: