From: | Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com> |
---|---|
To: | Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Linux |
Date: | 2010-11-04 15:54:40 |
Message-ID: | AANLkTik7YmQtGWsOJqd+StFN5MdrKr2=m9LSd-9gqC9G@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 4 November 2010 15:00, Michael Gould
<mgould(at)intermodalsoftwaresolutions(dot)net> wrote:
> I know that this is probably a "religion" issue but we are looking to move
> Postgres to a Linux server. We currently have a Windows 2008 R2 active
> directory and all of the other servers are virtualized via VMWare ESXi. One
> of the reasons is that we want to use a 64 bit Postgres server and the UUID
> processing contrib module does not provide a 64 bit version for Windows. I
> would also assume that the database when properly tuned will probably run
> faster in a *inx environment.
Let's not make the mistake of assuming that Windows and Linux are more
or less comparable as Postgres platforms - they aren't. Most large
installations are *nix based, and many tuning guides assume that you
are using some *nix flavour, or mention windows only very briefly. I'm
not sure of the details, but the windows System V IPC compatibility
layer (or whatever it's called) that we ship + windows, simply don't
work as well as native System V IPC running on the same hardware. This
is why users are encouraged to try lower shared_buffers settings on
windows - better results are attained on that platform by using
proportionally more file system/OS cache.
However, it is worth acknowledging that there has been some excellent
work towards getting Postgres to work well on Windows, which it now
does. I can personally attest to that.
--
Regards,
Peter Geoghegan
From | Date | Subject | |
---|---|---|---|
Next Message | Vick Khera | 2010-11-04 15:56:35 | Re: Linux |
Previous Message | Scott Marlowe | 2010-11-04 15:54:22 | Re: Linux |