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

Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Regression: 8.3 2 seconds -> 8.4 100+ seconds
Date: 2010-10-27 16:09:46
Message-ID: 21877.1288195786@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Francisco Reyes <lists(at)stringsutils(dot)com> writes:
> CentOS 5.4 and 5.5
> Query
> SELECT sum(usramt) as givensum,
>               sum (case when usedid > 0 then usramt else 0 end) as usedsum
>               FROM argrades
>               WHERE userstatus in (5) and
>               membid in (select distinct members.membid from members, cards
> where members.membid = cards.membid and members.membershipid = 40 and useraccount in
> ( select useraccount from cards where membid in
> (select membid from members where commonid = 3594)))

Please provide a self-contained test case for this.  In testing here,
8.4 can still figure out that it ought to use an indexscan against the
large table ... so there is some aspect of your tables that you're not
showing us.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Divakar SinghDate: 2010-10-27 16:12:24
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Previous:From: David WilsonDate: 2010-10-27 15:50:46
Subject: Re: Postgres insert performance and storage requirement compared to Oracle

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