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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
