From: Craig Ringer <craig@postnewspapers.com.au>
To: Tino Wildenhain <tino@wildenhain.de>
Cc: Mickey Shekdar <support@EF-USA.com>
Cc: pgadmin-support@postgresql.org, postgres general <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] PostgreSQL
Date: Mon, 15 Sep 2008 12:32:06 +0800
Message-ID: <48CDE546.30505@postnewspapers.com.au> (raw)
In-Reply-To: <48C8DA65.8000701@wildenhain.de>
References: <20080907135239.b92419df65edc5e9c7601656caf86ae8.fcf202b1ef.wbe@email.secureserver.net>
<48C8DA65.8000701@wildenhain.de>
Tino Wildenhain wrote:
>> [1] Will PostgreSQL perform better on Linux or Windows OS
>
> The performance is better on Linux, last but not least because
> it is developed and thus optimized there much longer then it
> is natively available for windows. Also system management is a lot
> more easy on unix like systems.
There are also a lot more PostgreSQL developers and users interested in
UNIX systems. While there appear to be lots of PostgreSQL users on
Windows now they don't seem to be very frequent contributors,
particularly active on the mailing lists, etc.
That's going to reduce the rate of PostgreSQL's improvement on Windows,
especially given how generally unpleasant the platform is to develop on*.
>> [2] What is the best RAID configuration/number of dives you recommend
>
> You should ask the vendor of your web booking engine, it really depends
> much on the nature of the transactions. Also have a look in the archive
> of the "postgresql general" - list, which is also much more appropriate
> then this list here.
The appropraite setup also depends on your controller's performance
characteristics, your particular workload, etc. If things are busy
enough you might even want to look at using tablespaces to split busy
tables on to separate volumes.
* Except Visual Studio's debugger, which I use a lot when I encounter
wacky problems in C++ code. gdb is OK for C, but awful for C++. It often
seems to be necessary to have two systems - a Linux one for valgrind and
everything else, plus a Windows one for VC++'s debugger.
--
Craig Ringer
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: craig@postnewspapers.com.au, tino@wildenhain.de, support@EF-USA.com
Subject: Re: [GENERAL] PostgreSQL
In-Reply-To: <48CDE546.30505@postnewspapers.com.au>
References: <20080907135239.b92419df65edc5e9c7601656caf86ae8.fcf202b1ef.wbe@email.secureserver.net> <48C8DA65.8000701@wildenhain.de> <48CDE546.30505@postnewspapers.com.au>
* 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