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