Re: Slow query help

P {margin-top:0;margin-bottom:0;}

>I ask your help to solve a slow query which is taking more than 14 seconds to be executed.
>Maybe I am asking too much both from you and specially from postgresql, as it is really huge, envolving 16 tables.
>
>Explain:
>http://explain.depesz.com/s/XII9
>
>Schema:
>http://adj.com.br/erp/data_schema/

Hello,

It seems that you don't pay much attention to column alignment.
e.g. http://adj.com.br/erp/data_schema/tables/ERP_PUBLIC_sys_person.html

This probably won't make any significant difference in your case,
but this is something to be aware of when dealing with large tables.
here is a good starting link for this topic:
http://stackoverflow.com/questions/12604744/does-the-order-of-columns-in-a-postgres-table-impact-performance

regards,

Marc Mamin

--
* { font-family:Helvetica, Arial, Sans-serif; } body { font-size:90%; } div { padding-left:0px; margin-left:4px; color:#000066; } a { text-decoration:none; color:#5C7A99; } a:hover { color:#7AA3CC; cursor:pointer; } .sign { font-size:0.85em; } .rights { font-size:0.75em; }

Att.,
 
Almir de Oliveira Duarte Junior, PMP

ADJ Tecnologia da Informação
Diretor
Tel: +55 (21) 3079-4128
Cel: +55 (21) 99362-7627
Skype: almir.duarte.jr
Email: almirjr@adj.com.br
Rua São José, 90 - sala 613 - Centro
Rio de Janeiro - RJ - CEP: 20.010-901

---

Copyright © 2013 FPASuite. Todos os direitos reservados