Hi,
I use PostGreSQL with a Web server which receive 200 HTTP simultaneous
queries.
For each HTTP query, I have about 5 SELECT queries and 3 UPDATE ones.
Queries have been optimized, I have INDEX on my tables...
The biggest table has more than 500 000 records.
And I have big troubles, PostGreSQL doesn't seem to be able to handle so
many queries at the same time.
The server is a NetFinity bi-proc 400 MHz with 1Gb RAM...
What can I do ??
Thanx in advance
Guillaume