Troubles with performances - Mailing list pgsql-general

From Guillaume Lémery
Subject Troubles with performances
Date
Msg-id 3A6730F8.1000607@comclick.com
Whole thread Raw
Responses Re: Troubles with performances
List pgsql-general
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


pgsql-general by date:

Previous
From: "Diehl, Jeffrey"
Date:
Subject: RE: Help with query. (*)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] GET DIAGNOSTICS SELECT PROCESSED INTO