Re: Prepared Statement Query Planning

Tom Lane wrote:

Brett Henderson <brett@bretth.com> writes: 

However I don't think it will work in my case.  I currently have three 
different ways of selecting records, 1. by timestamp range (as in my 
initial example), 2. by records in a temp table, and 3. unrestricted.  
The unrestricted example isn't an issue because a full table scan is 
appropriate in that case.  However the temp table one is a different 
matter.   

In the case of a temp table you have to ANALYZE the temp table after
filling it; otherwise the planner is working completely blind as to
what is in it.  (autovacuum will not do this for you...) 

Thanks for the tip.  I haven't tried the temp table queries yet.  They're next.