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:  [mailto:pgsql-performance-
> ] On Behalf Of Scott Marlowe
> Sent: Monday, April 13, 2009 8:41 AM
> To: Rainer Mager
> Cc: Ognjen Blagojevic; 
> Subject: Re: [PERFORM] Postgres 8.x on Windows Server in production
>
> On Sun, Apr 12, 2009 at 5:13 PM, Rainer Mager <>
> 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-
> )
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance