Brian Modra wrote:
> Great Idea, thanks, However, I notice that the postmaster seems idle,
> according to top, only 1% of the CPU at most... is it busy with IO
> maybe? Still seems strange that it sits at 0, or 1% ...
>
> Nothing else is running on the system...
>
> But when I use ps:
>
> postgres 8563 15633 0 Sep05 ? 00:05:01 postgres: tracker
> trackerData [local] VACUUM
Maybe your vacuum_cost_delay settings are too high? What do you have
them set to?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support