pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Bryce Nesbitt <bryce2@obviously.com>
To: Marc Mamin <M.Mamin@intershop.de>
To: pgsql-performance@postgresql.org
Cc: Shrirang Chitnis <Shrirang.Chitnis@hovservices.com>
Subject: Re: hashed subplan 5000x slower than two sequential operations
Date: Wed, 08 Dec 2010 12:33:57 -0800
Message-ID: <4CFFEBB5.8090401@obviously.com> (raw)
In-Reply-To: <C4DAC901169B624F933534A26ED7DF3103E915FC@JENMAIL01.ad.intershop.net>
References: <4CFFD446.6040609@obviously.com>
	<E6DB850FDAD49A459E3C217442489C9225FB9256AB@HOV-MAIL.hovservices.com>
	<C4DAC901169B624F933534A26ED7DF3103E915FA@JENMAIL01.ad.intershop.net>
	<C4DAC901169B624F933534A26ED7DF3103E915FC@JENMAIL01.ad.intershop.net>

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

view thread (11+ messages)  latest in thread

Message-ID: <4CFFEBB5.8090401@obviously.com>
Permalink:  ../4CFFEBB5.8090401@obviously.com/
Also on:    postgresql.org/message-id/4CFFEBB5.8090401@obviously.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: bryce2@obviously.com, M.Mamin@intershop.de, Shrirang.Chitnis@hovservices.com
  Subject: Re: hashed subplan 5000x slower than two sequential operations
  In-Reply-To: <4CFFEBB5.8090401@obviously.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox