Re: [PERFORM] PostgreSQL 9.3.2 Performance tuning for 32 GB server

2014-02-02 Thread Tom Kincaid
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 >

Re: [PERFORM] PHP Postgres query slower then PgAdmin

2013-06-23 Thread Tom Kincaid
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