Re: Regular disk activity of an idle DBMS

From: Andrej Podzimek <andrej(at)podzimek(dot)org>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Greg Smith <greg(at)2ndquadrant(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Regular disk activity of an idle DBMS
Date: 2011-05-30 16:52:47
Message-ID: 4DE3CB5F.2070602@podzimek.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> Nothing changes there. When OpenFire, Courier-MTA and Apache are restarted,
>> a few numbers change, but othrewise they remain unchanged pretty long. There
>> is no obvious activity that could trigger a disk write 20 times a minute...
>
> How many databases are in your pg cluster?

There are currently 19 of them, but only about 5 are used actively (queried at least once a day).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Carlos Sotto Maior (SIM) 2011-05-30 18:35:39 RES: SELECT COUNT(*) execution time on large tables (v9.0.4-1)
Previous Message Mathew Samuel 2011-05-30 14:29:02 UTC4115FATAL: the database system is in recovery mode