pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Richard Huxton <dev@archonet.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-performance@postgresql.org
Subject: Re: Recommendations for configuring a 200 GB database
Date: Thu, 09 Jun 2005 09:06:44 +0100
Message-ID: <42A7F894.40803@archonet.com> (raw)
In-Reply-To: <s2a71722.022@gwmta.wicourts.gov>
References: <s2a71722.022@gwmta.wicourts.gov>

Kevin Grittner wrote:
>   
> The manager of the DBA team is reluctant to change both the OS and the
> DBMS at the same time, so unless I can make a strong case for why it is
> important to run postgresql under Linux, we will be running this on
> Windows.  Currently, there are two Java-based middle tier processes
> running on each central database server, one for the replication and one
> for the web.  We expect to keep it that way, so the database needs to
> play well with these processes. 

Well, there's a lot more experience running PG on various *nix systems 
and a lot more help available. Also, I don't think performance on 
Windows is as good as on Linux/*BSD yet.

Against switching OS is the fact that you presumably don't have the 
skills in-house for it, and the hardware was chosen for Windows 
compatibility/performance.

Speaking of which, what sort of hardware are we talking about?

--
   Richard Huxton
   Archonet Ltd



view thread (4+ messages)  latest in thread

Message-ID: <42A7F894.40803@archonet.com>
Permalink:  ../42A7F894.40803@archonet.com/
Also on:    postgresql.org/message-id/42A7F894.40803@archonet.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dev@archonet.com, Kevin.Grittner@wicourts.gov
  Subject: Re: Recommendations for configuring a 200 GB database
  In-Reply-To: <42A7F894.40803@archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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