>> I use PostGreSQL with a Web server which receive 200 HTTP
>> simultaneous queries.
>
>
> With what opts do you start postmaster?
-F to disable fsync()
I don't know if I have to use the -B and -S options to change the memory
use...
>> For each HTTP query, I have about 5 SELECT queries and 3 UPDATE ones.
> Do you use BEGIN/END to run queries in one transaction, when appropriate?
Yep...
In fact, I have 3 SELECT and the 3 UPDATE in a PL/PGSQL Function...