| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Brian Modra <epailty(at)googlemail(dot)com> |
| Cc: | Kevin Kempter <kevink(at)consistentstate(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: server disk space |
| Date: | 2009-09-07 15:20:17 |
| Message-ID: | 20090907152017.GK8894@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Fontaine | 2009-09-07 18:58:49 | Re: POSTGRES.. NEED HELP |
| Previous Message | Richy Gerard | 2009-09-07 15:18:53 | POSTGRES.. NEED HELP |