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

Re: Very poor performance

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Aaron Burnett" <aburnett(at)bzzagent(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Very poor performance
Date: 2010-08-17 14:18:21
Message-ID: 4C6A53DD0200002500034739@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
"Aaron Burnett" <aburnett(at)bzzagent(dot)com> wrote:
 
> Postgres Version 8.25
 
Do you mean 8.2.5?  (There is no PostgreSQL version 8.25.)
 
If you're concerned about performance and you're still on 8.2, you
might want to consider updating to a new major version.
 
> 16 Gig RAM
> 192MB work_mem  (increasing to 400MB didn't change the outcome)
 
What other non-default settings do you have?
 
> explain analyze select distinct(id) from member  where id in
> (select memberid from answerselectinstance where   nswerid =
> 127443  OR answerid = 127444  OR  answerid = 127445  OR  answerid
> = 127446  OR  answerid = 127447  OR  answerid = 127448   ) ;
 
How does this do?:
 
explain analyze
select distinct(m.id)
  from answerselectinstance a
  join member m
    on m.id = a.memberid
  where a.answerid between 127443 and 127448
;
 
-Kevin

In response to

Responses

pgsql-performance by date

Next:From: Alvaro HerreraDate: 2010-08-17 15:07:39
Subject: Re: Quesion on the use of indexes
Previous:From: Pavel StehuleDate: 2010-08-17 10:49:05
Subject: Re: Search query is curious

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