Re: how to improve perf of 131MM row table?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I will try this, but can you clarify the syntax?  I only know the VALUES clause from insert statements, and it would be one set of parens like VALUES('175769', '175771', ... )

You seem to indicate a VALUES clause that has strange parenthesis corresponding to it.

Thank you for the feedback and offer to help!

-AJ

On 6/26/2014 9:56 AM, Matheus de Oliveira wrote:

On Thu, Jun 26, 2014 at 10:26 AM, AJ Weber <aweber@xxxxxxxxxxx> wrote:
OK, the sample query is attached (hopefully attachments are allowed) as "query.sql".
The "master table" definition is attached as "table1.sql".
The "detail table" definition is attached as "table2.sql".
The EXPLAIN (ANALYZE, BUFFERS) output is here: http://explain.depesz.com/s/vd5

Could you try chaning your query and sending the EXPLAIN of the following?

Instead of `node_id in ('175769', '175771', ...)` try `node_in IN (VALUES('175769'), ('175771'), ... )`.


--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux