Skip site navigation (1) Skip section navigation (2)

Re: two queries and dual cpu (perplexed)

From: Gavin Sherry <swm(at)alcove(dot)com(dot)au>
To: Jeff <threshar(at)torgo(dot)978(dot)org>
Cc: "Shoaib Burq (VPAC)" <sab(at)vpac(dot)org>,pgsql-performance(at)postgresql(dot)org
Subject: Re: two queries and dual cpu (perplexed)
Date: 2005-04-21 12:33:26
Message-ID: Pine.LNX.4.58.0504212231080.31127@linuxworld.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, 21 Apr 2005, Jeff wrote:

>
> On Apr 21, 2005, at 7:49 AM, Shoaib Burq (VPAC) wrote:
>
> > Now I have not touch the $PGDATA/postgresql.conf (As I know very little
> > about memory tuning) Have run VACCUM & ANALYZE.
> >
> You should really, really bump up shared_buffers and given you have 8GB
> of ram this query would likely benefit from more work_mem.

I'd recommend shared_buffers = 10600. Its possible that work_mem in the
hundreds of megabytes might have a good impact, but its hard to say
without seeing the EXPLAIN ANALYZE output.

Gavin


In response to

pgsql-performance by date

Next:From: Kenneth MarshallDate: 2005-04-21 12:36:23
Subject: Re: two queries and dual cpu (perplexed)
Previous:From: JeffDate: 2005-04-21 12:24:15
Subject: Re: two queries and dual cpu (perplexed)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group