Re: Troubles with performances - Mailing list pgsql-general

From Guillaume Lémery
Subject Re: Troubles with performances
Date
Msg-id 3A6738EC.4040006@comclick.com
Whole thread Raw
In response to Troubles with performances  (Guillaume Lémery <glemery@comclick.com>)
List pgsql-general
>> 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...



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: plperl and sqrt.
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: Troubles with performances