Re: Postgres 8.x on Windows Server in production

From: Rainer Mager
Subject: Re: Postgres 8.x on Windows Server in production
Date: ,
Msg-id: 000001c9bbc4$5540e430$ffc2ac90$@com
(view: Whole thread, Raw)
In response to: Postgres 8.x on Windows Server in production  (Ognjen Blagojevic)
Responses: Re: Postgres 8.x on Windows Server in production  (Scott Marlowe)
List: pgsql-performance

Tree view

Postgres 8.x on Windows Server in production  (Ognjen Blagojevic, )
 Re: Postgres 8.x on Windows Server in production  (Josh Berkus, )
  Re: Postgres 8.x on Windows Server in production  (Grzegorz Jaśkiewicz, )
   Re: Postgres 8.x on Windows Server in production  (Ognjen Blagojevic, )
    Re: Postgres 8.x on Windows Server in production  (Scott Marlowe, )
    Re: Postgres 8.x on Windows Server in production  (Grzegorz Jaśkiewicz, )
    Re: Postgres 8.x on Windows Server in production  (Justin Pitts, )
 Re: Postgres 8.x on Windows Server in production  ("Rainer Mager", )
  Re: Postgres 8.x on Windows Server in production  (Scott Marlowe, )
   Re: Postgres 8.x on Windows Server in production  ("Rainer Mager", )
    Re: Postgres 8.x on Windows Server in production  (Scott Marlowe, )

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.

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
O&O (that's the company name) Defrag Server version. Their software has some
nice features related to defragging in the background while monitoring
system usage so an to impact performance minimally.

Second, one big difficulty with running on Windows is that most of the
Postgres expertise seems is around *nix environments. This means that when
you do need to investigate a performance issue it can be more difficult to
get direct advice. For example, perusing this mailing list will show lot's
of tips suggesting running various tools to show io performance, etc. Well,
on Windows the toolset is different.


All in all we've been happy enough with Windows. Certainly we've never
considered migrating to *nix because of difficulties with it.



--Rainer

> -----Original Message-----
> From:  [mailto:pgsql-performance-
> ] On Behalf Of Ognjen Blagojevic
> Sent: Friday, April 10, 2009 6:47 PM
> To: 
> Subject: [PERFORM] Postgres 8.x on Windows Server in production
>
> Hi all,
>
> What are your experiences with Postgres 8.x in production use on
> Windows
> Server 2003/2008? Are there any limitations, trade-offs or quirks?
>
> My client is accustomed to Windows Server environment, but it seems
> hard
> to google good information about these types of installations.
>
> Regards,
> Ognjen
>
> --
> Sent via pgsql-performance mailing list (pgsql-
> )
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance



pgsql-performance by date:

From: Scott Marlowe
Date:
Subject: Re: Postgres 8.x on Windows Server in production
From: Greg Smith
Date:
Subject: Re: 2.6.26 kernel and PostgreSQL