Re: resource allocation ; postgresql-8.0 - Mailing list pgsql-admin

From Kavan, Dan (IMS)
Subject Re: resource allocation ; postgresql-8.0
Date
Msg-id 782D2A81EC812642B857B03B506E0B4432648E@granite.omni.imsweb.com
Whole thread Raw
Responses Re: resource allocation ; postgresql-8.0
List 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



pgsql-admin by date:

Previous
From: "Kavan, Dan (IMS)"
Date:
Subject: Re: memory allocation ; postgresql-8.0
Next
From: Prasanth
Date:
Subject: Re: Query Plan - Index Scan & Seq Scan