Re: Optimizer problem in 8.1.6

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Optimizer problem in 8.1.6
Date: 2007-06-22 16:10:39
Message-ID: A6D9C807-1FD2-4369-BDF1-6B5ECB1ECD01@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Jun 22, 2007, at 10:16 , Fernando Schapachnik wrote:

> EXPLAIN SELECT DISTINCT p.id

Can you provide EXPLAIN ANALYZE? I suspect that when you rewrote the
query it changed how the planner took into account the statistics. If
your statistics are off, perhaps this changes how the planner
rewrites the query.

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2007-06-22 16:21:48 Re: Optimizer problem in 8.1.6
Previous Message Alvaro Herrera 2007-06-22 16:09:35 Re: Accent insensitive search