running two instances of pg

From: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: running two instances of pg
Date: 2008-07-07 14:28:25
Message-ID: 1215440905.8449.11.camel@jmf-ubuntu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

we are using PostgreSQL in a situation where I think we could try and
run two separate instances:

- 1 application can grow up to 10 Giga data; needs 'frequent' vaccuming
and re-indexing (lots of insert, updates and deletes, per minute): we
use it for 'near-real-time' applications logs storage; not big problem
if it runs in lower priority;
- 1 very small application with high responsivness requirements (few
updates, very small size on disk); must run in high priority in order to
prevent service failure to the end users;

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)

So... my question is: is it a good approach to separate the 2 "worlds"
into 2 diferent databases and 2 diferent postmasters ?

is it good idea to "renice postmaster" ?

what other measures could we take to prevent the postmaster service of
the big database from consuming so much CPU during maintenance
operations ?

thanks a lot on your feedback

Joao

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-07-07 14:40:23 Re: running two instances of pg
Previous Message Tom Lane 2008-07-07 14:20:51 Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ?