Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimize a big matrix select - Mailing list pgsql-novice

From Kevin Grittner
Subject Re: Optimize a big matrix select
Date
Msg-id 2042051212.2920045.1427467640663.JavaMail.yahoo@mail.yahoo.com
Whole thread Raw
In response to Optimize a big matrix select  (Florian Schaetz <Florian.Schaetz@Optitool.DE>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Florian Schaetz
Date:
Subject: Optimize a big matrix select
Next
From: Florian Schaetz
Date:
Subject: Re: Optimize a big matrix select