Postgres Pro
Downloads
Home   >   mailing lists

Re: hashed subplan 5000x slower than two sequential operations - Mailing list pgsql-performance

From Bryce Nesbitt
Subject Re: hashed subplan 5000x slower than two sequential operations
Date
Msg-id 4CFFEBB5.8090401@obviously.com
Whole thread Raw
In response to Re: hashed subplan 5000x slower than two sequential operations  ("Marc Mamin" <M.Mamin@intershop.de>)
Responses Re: hashed subplan 5000x slower than two sequential operations
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Bryce Nesbitt
Date:
Subject: Re: hashed subplan 5000x slower than two sequential operations
Next
From: Robert Haas
Date:
Subject: Re: Performance under contention