RE: Troubles with performances - Mailing list pgsql-general

From Mikheev, Vadim
Subject RE: Troubles with performances
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D3294@sectorbase1.sectorbase.com
Whole thread Raw
In response to Troubles with performances  (Guillaume Lémery <glemery@comclick.com>)
Responses RE: Troubles with performances
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...

With 200 simult connections I would recomment to use
-N 256 -B 16384

Vadim

pgsql-general by date:

Previous
From: "Mikheev, Vadim"
Date:
Subject: RE: Troubles with performances
Next
From: Emmanuel Charpentier
Date:
Subject: Re: RE: Why is there so much MySQL bashing???