| 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
| 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 |