Re: Incorrect estimates on correlated filters

From: Decibel! <decibel(at)decibel(dot)org>
To: Chris Kratz <chris(dot)kratz(at)vistashare(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Incorrect estimates on correlated filters
Date: 2008-08-16 18:21:47
Message-ID: 79BDF0DC-E61B-4790-89A0-88069D44F6F0@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Aug 13, 2008, at 1:45 PM, Chris Kratz wrote:
> Yes, I know hints are frowned upon around here. Though, I'd love
> to have them or something equivalent on this particular query just
> so the customer can run their important reports. As it is, it's
> unrunnable.

Actually, now that I think about it the last time this was brought up
there was discussion about something that doesn't force a particular
execution method, but instead provides improved information to the
planner. It might be worth pursuing that, as I think there was less
opposition to it.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Decibel! 2008-08-16 18:45:53 Re: Experiences storing binary in Postgres
Previous Message Mark Mielke 2008-08-16 15:01:31 Re: file system and raid performance