Re: The planner hates me. - Mailing list pgsql-general

From Jeff Amiel
Subject Re: The planner hates me.
Date
Msg-id C17A452040EDB84AA7A10AEA334E3E1455D1CF@AD1
Whole thread Raw
In response to The planner hates me.  ("Jeff Amiel" <JAmiel@istreamimaging.com>)
List pgsql-general
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]


The Right Way (tm) to do this would be something like

    create temp table dates as select * from get_dates(...);
    analyze dates;
    ... original select, but join against temp table ...

which would leave the planner armed with some stats about the range
of dates of interest.

------------

I actually tried that   but minus the analyze..... :(

Btw, congrats on whomever contributed to the bitmap scans (v8.1 I
believe)....the ability to use multiple indexes for a single table in
the same query is fantastic!!




pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)
Next
From: Casey Allen Shobe
Date:
Subject: Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)