Search Postgresql Archives

Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
From: "shakahshakah@xxxxxxxxx" <shakahshakah@xxxxxxxxx>
Date: 29 Jan 2007 12:14:47 -0800
Complaints-to: groups-abuse@xxxxxxxxxx
In-reply-to: <1170099377.393327.173370@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Injection-info: l53g2000cwa.googlegroups.com; posting-host=169.132.93.80; posting-account=aP_RZQwAAAA-BzZVas_iPh7gxf_bc-P2
Organization: http://groups.google.com
References: <1170099377.393327.173370@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
User-agent: G2/1.0

Never mind.

I found "vacuum_cost_delay" in the docs, I had it set to 70. I set it 
to 0 and watched CPU and I/O% peg to 100%.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
  - From: Jim Nasby

References:
- VACUUM ANALYZE taking a long time, %I/O and %CPU very low
  - From: shakahshakah@xxxxxxxxx

Prev by Date: Re: Limit on number of users in postgresql?
Next by Date: Re: Locking question?
Previous by thread: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
Next by thread: Re: VACUUM ANALYZE taking a long time, %I/O and %CPU very low
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux