Re: Optimize a big matrix select

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