Re: Recommendations for configuring a 200 GB database - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Recommendations for configuring a 200 GB database
Date
Msg-id 42A7F894.40803@archonet.com
Whole thread Raw
In response to Recommendations for configuring a 200 GB database  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Jona
Date:
Subject: Re: Query plan changes after pg_dump / pg_restore
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Query plan changes after pg_dump / pg_restore