Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group