Thread: PostgreSQL
<span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>Hello,</div><div> </div><div>We are switching ourweb booking engine vendor. The present vendor is using Microsoft SQL and the new vendor uses PostgreSQL.</div><div> </div><div>Ihave three questions and will appreciate your comments:</div><div> </div><div>[1] WillPostgreSQL perform better on Linux or Windows OS</div><div>[2] What is the best RAID configuration/number of dives yourecommend</div><div>[3] Is there a hosting company offering fully monitored/managed PostgreSQL</div><div> </div><div>Yourresponse will be highly appreciated</div><div> </div><div>Mickey Shekdar</div><div><strong><fontcolor="#990000">718-980-6321</font></strong></div></span>
Mickey Shekdar wrote: > Hello, > > We are switching our web booking engine vendor. The present vendor is > using Microsoft SQL and the new vendor uses PostgreSQL. > > I have three questions and will appreciate your comments: > > [1] Will PostgreSQL perform better on Linux or Windows OS The performance is better on Linux, last but not least because it is developed and thus optimized there much longer then it is natively available for windows. Also system management is a lot more easy on unix like systems. > [2] What is the best RAID configuration/number of dives you recommend You should ask the vendor of your web booking engine, it really depends much on the nature of the transactions. Also have a look in the archive of the "postgresql general" - list, which is also much more appropriate then this list here. > [3] Is there a hosting company offering fully monitored/managed PostgreSQL Yes, plenty. Please check the webpage of postgresql.org Cheers Tino Wildenhain
Attachment
Tino Wildenhain wrote: >> [1] Will PostgreSQL perform better on Linux or Windows OS > > The performance is better on Linux, last but not least because > it is developed and thus optimized there much longer then it > is natively available for windows. Also system management is a lot > more easy on unix like systems. There are also a lot more PostgreSQL developers and users interested in UNIX systems. While there appear to be lots of PostgreSQL users on Windows now they don't seem to be very frequent contributors, particularly active on the mailing lists, etc. That's going to reduce the rate of PostgreSQL's improvement on Windows, especially given how generally unpleasant the platform is to develop on*. >> [2] What is the best RAID configuration/number of dives you recommend > > You should ask the vendor of your web booking engine, it really depends > much on the nature of the transactions. Also have a look in the archive > of the "postgresql general" - list, which is also much more appropriate > then this list here. The appropraite setup also depends on your controller's performance characteristics, your particular workload, etc. If things are busy enough you might even want to look at using tablespaces to split busy tables on to separate volumes. * Except Visual Studio's debugger, which I use a lot when I encounter wacky problems in C++ code. gdb is OK for C, but awful for C++. It often seems to be necessary to have two systems - a Linux one for valgrind and everything else, plus a Windows one for VC++'s debugger. -- Craig Ringer