Tom Lane wrote:
> Brett Henderson <brett(at)bretth(dot)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.