Florian Schaetz <Florian.Schaetz@Optitool.DE> wrote:
> The TEMP_TABLE simply contains the list of integers as “point”
> (with an index).
Did you run ANALYZE on TEMP_TABLE after loading data and before
running your query?
You're not doing a lot of deletes or updates in TEMP_TABLE at any
point, are you?
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company