Re: hashed subplan 5000x slower than two sequential operations

From: Bryce Nesbitt <bryce2(at)obviously(dot)com>
To: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, pgsql-performance(at)postgresql(dot)org
Cc: Shrirang Chitnis <Shrirang(dot)Chitnis(at)hovservices(dot)com>
Subject: Re: hashed subplan 5000x slower than two sequential operations
Date: 2010-12-08 20:33:57
Message-ID: 4CFFEBB5.8090401@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Marc Mamin wrote:
>
> Another point: would a conditionl index help ?
> on articles (context_key) where indexed
>
no.

production=> select count(*),indexed from articles group by indexed;
count | indexed
--------+---------
517433 | t
695814 | f

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2010-12-08 21:09:17 Re: Performance under contention
Previous Message Bryce Nesbitt 2010-12-08 20:31:53 Re: hashed subplan 5000x slower than two sequential operations