pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: resource allocation ; postgresql-8.0
2+ messages / 2 participants
[nested] [flat]

* Re: resource allocation ; postgresql-8.0
@ 2005-05-12 17:56 Kavan, Dan (IMS) <KavanD@imsweb.com>
  2005-05-12 19:13 ` Re: resource allocation ; postgresql-8.0 Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Kavan, Dan (IMS) @ 2005-05-12 17:56 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Scott Marlowe <smarlowe@g2switchworks.com>

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: resource allocation ; postgresql-8.0
  2005-05-12 17:56 Re: resource allocation ; postgresql-8.0 Kavan, Dan (IMS) <KavanD@imsweb.com>
@ 2005-05-12 19:13 ` Scott Marlowe <smarlowe@g2switchworks.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Scott Marlowe @ 2005-05-12 19:13 UTC (permalink / raw)
  To: Kavan, Dan (IMS) <KavanD@imsweb.com>; +Cc: pgsql-admin

On Thu, 2005-05-12 at 12:56, Kavan, Dan (IMS) wrote:
> 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 haven't, but I could see where, if the workloads were very different,
it might be advantageous.

> 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.

Possible.  It really depends on how different they are.  There are
benefits to having only one postmaster running, but since you've got
3gigs+ memory, the memory savings probably isn't one of them.  

>   Two, from a networking perspective, it may
> be faster ( 2 different ports rather than one )

I doubt that would be a big difference.

> Do you agree with those
> reasons or can you think of other reasons it would be wise?

Well, running two separate clusters under separate postgres superuser
account would afford the maximum in isolation.  Plus you could easily
place each cluster on it's own storage to provide better performance and
keep them from interacting with each other.  If, at some later date you
decide to put them on separate machines you're aleady halfway there.

> 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.

Exactly. You need to schedule separate vacuums for each, etc...

I tend to leave it on one cluster unless performance starts to become an
issue.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-05-12 19:13 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-12 17:56 Re: resource allocation ; postgresql-8.0 Kavan, Dan (IMS) <KavanD@imsweb.com>
2005-05-12 19:13 ` Scott Marlowe <smarlowe@g2switchworks.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox