Skip site navigation (1) Skip section navigation (2)

Re: The planner hates me.

From: "Jeff Amiel" <JAmiel(at)istreamimaging(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: The planner hates me.
Date: 2008-09-25 22:18:42
Message-ID: C17A452040EDB84AA7A10AEA334E3E1455D1CF@AD1 (view raw or flat)
Thread:
Lists: pgsql-general
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)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!!




In response to

pgsql-general by date

Next:From: Casey Allen ShobeDate: 2008-09-25 23:38:18
Subject: Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)
Previous:From: Greg SmithDate: 2008-09-25 22:08:37
Subject: Re: Obfuscated stored procedures (was Re: Oracle and Postgresql)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group