Re: Postgres 8.x on Windows Server in production

Список
Период
Сортировка
От Rainer Mager
Тема Re: Postgres 8.x on Windows Server in production
Дата
Msg-id 000101c9bbc9$4f190470$ed4b0d50$@com
обсуждение исходный текст
Ответ на Re: Postgres 8.x on Windows Server in production  (Scott Marlowe)
Ответы Re: Postgres 8.x on Windows Server in production  (Scott Marlowe)
Список pgsql-performance
Дерево обсуждения
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'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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Postgres 8.x on Windows Server in production
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Postgres 8.x on Windows Server in production