Обсуждение: Pgsql 8.0 on Win32 Production env.
Hello all, I have to build a web application and for this I have to use one of my client's Windows32 server or workstation. Is postgresql 8.0 native suitable for a production environment? Thanks for any advice. Fabri ___________________________________ Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar, Webcam, Giochi, Rubrica Scaricalo ora! http://it.messenger.yahoo.it
On Thu, 2005-03-24 at 10:31, fabrizio ravazzini wrote: > Hello all, I have to build a web application and for > this I have to use one of my client's Windows32 > server or workstation. > Is postgresql 8.0 native suitable for a production > environment? > Thanks for any advice. > Fabri That really depends on what you mean by production. Are you gonna handle a workgroup of 10 or 15 people doing a phonebook type application, or are you going to handle 250,000 transactions a day in a reservation system? For certain values of production environment, pgsql on windows is probably fine. But until YOU test it under your own load, you won't really know, and neither will we.
I have been using the win32 version of PG 8.0 on a windows 2003 server since sept 2004 and it's for a financial daily pricing application using apache 2.5x. I have a Delphi win32 app that the users use to update the database with data from a spreadsheet, the app then updates the tables used for the daily pricing web CGI and this happens twice per day. The web page is then hit all day long pulling the info from the PG tables. I ported the app from MS SQL server 7 and I can tell you it runs just as good if not better. We even ran this whole thing on the early win32 beta's from Aug 04 and never had one hicup. Very impressive is you ask me(PG 8.x). later, Tony On Thursday 24 March 2005 10:31 am, fabrizio ravazzini wrote: > Hello all, I have to build a web application and for > this I have to use one of my client's Windows32 > server or workstation. > Is postgresql 8.0 native suitable for a production > environment? > Thanks for any advice. > Fabri > > > > > ___________________________________ > Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar, Webcam, > Giochi, Rubrica Scaricalo ora! http://it.messenger.yahoo.it > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend