Re: Postgres 8.x on Windows Server in production

We're running 8.3, but when we started this server about 2 years ago it was
an earlier 8.x, I don't remember which.

--Rainer

> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-
> owner(at)postgresql(dot)org] On Behalf Of Scott Marlowe
> Sent: Monday, April 13, 2009 8:41 AM
> To: Rainer Mager
> Cc: Ognjen Blagojevic; pgsql-performance(at)postgresql(dot)org
> Subject: Re: [PERFORM] Postgres 8.x on Windows Server in production
>
> On Sun, Apr 12, 2009 at 5:13 PM, Rainer Mager <rainer(at)vanten(dot)com>
> wrote:
> > We use Postgres 8.x in production on Windows Server 2003. We have not
> done a
> > direct head-to-head comparison against any *nix environment, so I
> can't
> > really compare them, but I can still give a few comments.
>
> Just wondering, what version are you actually running? Big
> differences from 8.0, 8.1, 8.2, 8.3 and soon 8.4. For people taking
> your advice on running on windows, it helps them make a decision on
> whether or not to upgrade.
>
> > First of all, it seems that some of the popular file systems in *nix
> are
> > more robust at preventing disk fragmentation than NTFS is. Because of
> this I
> > definitely recommend have some defragging solution. What we've
> settled on in
>
> Linux file systems still fragment, they just don't tend to fragment as
> much. As the drive gets closer to being full fragmentation will
> become more of a problem.
>
> --
> Sent via pgsql-performance mailing list (pgsql-
> performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance