On Fri, Jan 31, 2014 at 8:55 AM, Julien Cigar wrote:
> On Sat, Jan 25, 2014 at 12:02:59PM +0530, RAMAKRISHNAN KANDASAMY wrote:
> > Hi All,
> >
> > I have configured the blow parameters for a 32 GB server . I this
> correct ?
> >
> > shared_buffers = 6GB
>
> going over 2GB probably doesn't help
>
Just rule out something weird;
Can you determine if you are getting the same query plan in both cases? Use
"explain analyze" from the command line and turn on auto.explain via
postgresql.conf to log what the plan is for the php case.
Tom Kincaid
EnterpriseDB
www.enterprisedb.com
O