Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer problem in 8.1.6 - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Optimizer problem in 8.1.6
Date
Msg-id A6D9C807-1FD2-4369-BDF1-6B5ECB1ECD01@seespotcode.net
Whole thread Raw
In response to Optimizer problem in 8.1.6  (Fernando Schapachnik <fernando@mecon.gov.ar>)
Responses Re: Optimizer problem in 8.1.6  (Fernando Schapachnik <fschapachnik@mecon.gov.ar>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Accent insensitive search
Next
From: "Charles Mortell"
Date:
Subject: How determine a Views dependents