Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2
Date: 2011-01-19 17:26:56
Message-ID: 21792.1295458016@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
> Anyway, i will repost the EXPLAIN plans by copying pasting the query, without the analyze part.

Please show EXPLAIN ANALYZE, not just EXPLAIN, results. When
complaining that the planner did the wrong thing, it's not very helpful
to see only its estimates and not reality.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2011-01-19 17:27:30 Re: Running PostgreSQL as fast as possible no matter the consequences
Previous Message Bruce Momjian 2011-01-19 17:07:24 Re: Running PostgreSQL as fast as possible no matter the consequences