Search Postgresql Archives

Re: Re: Moving a live production database to different server and postgres release

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 15 Jun 2010, at 9:21, Guillaume Lelarge wrote:

> Le 15/06/2010 09:18, Ulas Albayrak a écrit :
>> Unfortunately, the switch to Windows is out of my hands. If it were up
>> to me I'd stick with BSD. When you say postgres on Windows is known
>> for its "mediocre performance", do you mean it's slower or buggy? Or
>> both?
>> 
> 
> Slower. If it were buggy, it would be fixed.


Yes, bugs do get fixed, but bugs that haven't been fixed yet are still bugs.

Why I'm saying this is that Postgres on Windows is relatively new compared to other operating systems. In general, the longer software exists and the more users it has on a certain operating system, the more bugs get fixed.

Now I don't know the usage numbers on the different operating systems, the number of implementations on Windows has definitely grown a lot in the last years, but historically the Windows version used to have a relatively small user base and was therefore more likely to contain bugs.

That aside, I think Windows is the only supported OS that has API's that differ a lot from the usual API's that Postgres was developed for. Therefore the Windows version has its own set of potential problems.

I'm not saying that Postgres on Windows is buggy, I'm just saying that the chances you run into one are relatively speaking higher on Windows than on other operating systems. If you check the archives you won't see a lot of bug reports though, no matter what OS people are using.

And yes, it's slower on Windows. IIRC that's because Windows isn't very good at multi-processing and Postgres runs as multiple processes.

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4c17598b286211489720513!



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux