Hi!I have no experience running postgreSQL under windows but when reading the Windows FAQ (http://www.postgresql.org/docs/faqs.FAQ_windows.html#4.4 ) Its seem like you can get in trouble with some of the libraries that postgres uses.
Regarding performance it's hard to tell because of all the different factors like raid type/disk count/type of queries/indexes etc. etc.
But it sounds like the machine is to weak to handle 1000 concurrent queries.
Best regards, Mathias Stjernstrom _____________________________________ Weblog at http://www.stjernstrom.se/ On 4 aug 2008, at 17.49, Kesavan wrote:
Hi We are using PostgreSQL 8.3.1 version under windows.We want to know whether there is any limit on Maximum number of concurrent users.In specific, can Postgres handle 1000 concurrent queries? Regarding our Data size, We have 40 tables and in total we have 2GB data.We are using normal Pentium Quad core processor, 3GHZ system with 2GB RAM as Database Server.Kindly provide your inputs. Thanks in advance S.Kesavan Emmeskay Systems, Chennai, India. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Attachment:
PGP.sig
Description: This is a digitally signed message part
