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: (view raw, whole thread or download thread mbox)
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(
  from answerselectinstance a
  join member m
    on = a.memberid
  where a.answerid between 127443 and 127448

In response to


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-2017 The PostgreSQL Global Development Group