Re: resource allocation ; postgresql-8.0

From: "Kavan, Dan (IMS)" <KavanD(at)imsweb(dot)com>
To: "postgres" <pgsql-admin(at)postgresql(dot)org>
Cc: "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>
Subject: Re: resource allocation ; postgresql-8.0
Date: 2005-05-12 17:56:34
Message-ID: 782D2A81EC812642B857B03B506E0B4432648E@granite.omni.imsweb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Scott,
If you had two applications that were each connecting to two different
databases, have you found that it's beneficial to have to different
instances of postgres running?

I have a few reasons why I think it would be better. One, it would be
beneficial to customize parameters for each application. They would be
different sizes for example and they may each have different amounts of
people connecting to them. Two, from a networking perspective, it may
be faster ( 2 different ports rather than one ) Do you agree with those
reasons or can you think of other reasons it would be wise? It seems
like it would be more administrative work to have 2 different instances,
so there may be some cons to that idea as well.

~DjK

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Prasanth 2005-05-12 18:49:01 Re: Query Plan - Index Scan & Seq Scan
Previous Message Kavan, Dan (IMS) 2005-05-12 17:46:27 Re: memory allocation ; postgresql-8.0