Joao Ferreira gmail <joao.miguel.c.ferreira@xxxxxxxxx> writes: > So we are considereing separating these two, in order to use 2 diferent > pg instances. One of the instances will be reniced down in order to > prevent user access failure during vacuuming and re-indexing operations > (currently, when we perform database maintenance (we are now at 2Giga > and growing), several other user related services become inoperative, > during the maintenance operation, but if we renice the postmaster, the > users dont experience such a severe service outage) Have you experimented with the vacuum cost delay settings, instead? "renice" is not a very good tool for controlling I/O demands. regards, tom lane
