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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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