Re: [PERFORM] Very poor performance

2010-08-17 Thread Aaron Burnett
Thanks for the response kevin. Answers interspersed below. On 8/17/10 10:18 AM, "Kevin Grittner" wrote: > "Aaron Burnett" wrote: > >> Postgres Version 8.25 > > Do you mean 8.2.5? (There is no PostgreSQL version 8.25.) > Yeah, missed a &#x

Re: [PERFORM] Very poor performance

2010-08-16 Thread Aaron Burnett
From: Mark Rostron [mailto:mrost...@ql2.com] Sent: Mon 8/16/2010 9:51 PM To: Aaron Burnett; pgsql-performance@postgresql.org Subject: RE: Very poor performance This is weird - is there a particular combination of memberid/answered in answerselectindex that has a very high rowcount? First

[PERFORM] Very poor performance

2010-08-16 Thread Aaron Burnett
Hi, I'm hoping someone can offer some help here. The query and explain analyze and table layout are below and attached in a text file if the formatting is bad. The query is part of a bigger query that our front end runs. This is the part that takes forever (84 minutes in this case) to finish