Re: Slow query help

[Almir de Oliveira Duarte Junior <almirjr@xxxxxxxxxx>]

Hi Marc,

Thank you very much!

Almir
====
On 01/07/2016 05:15 PM, Marc Mamin wrote:

>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

--

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@xxxxxxxxxx
Rua São José, 90 - sala 613 - Centro
Rio de Janeiro - RJ - CEP: 20.010-901

---

Copyright © 2013 FPASuite. Todos os direitos reservados