Re: Optimal platform for pg?

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Mark Williamson <thetazzbot(at)gmail(dot)com>
Cc: "pgsql-general(at)postgres(dot)org" <pgsql-general(at)postgres(dot)org>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Optimal platform for pg?
Date: 2009-12-16 02:48:35
Message-ID: 4B284A83.1040208@postnewspapers.com.au
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 16/12/2009 10:31 AM, Mark Williamson wrote:
> What is the most ideal/optimal platform for postgresql? Linux
> (distro?), freebsd, windows, etc.

Pg has been around on UNIX-like platforms for longer than Windows, and
is better tested on those platforms. Its design is also more friendly
toward UNIX-like systems, being based on a connection-per-process rather
than connection-per-thread model - though that matters less with the NT
kernel used in all modern Windows flavours.

Of the UNIX-like systems, the vast majority of people on the list seem
to use a Linux flavour or FreeBSD. I mostly see Red Hat Enterprise,
FreeBSD, Ubuntu, Debian, and CentOS users when OS is mentioned.

I'd stick to whatever Linux/BSD you're most familiar with, personally.

Rather than worry about OS, though, your real issues are with hardware
selection. Getting a good quality RAID controller with battery backup,
plus plenty of disks in RAID 10 and plenty of RAM will make more
difference than about anything else.

--
Craig Ringer

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Philip Graham 2009-12-16 04:18:01 Re: BUG #5244: Attempting to rollback to a savepoint after receiving an error with state 55000 the process hangs
Previous Message Mark Williamson 2009-12-16 02:31:00 Optimal platform for pg?