Re: Slow query help

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(at)adj(dot)com(dot)br
Rua São José, 90 - sala 613 - Centro
Rio de Janeiro - RJ - CEP: 20.010-901

------------------------------------------------------------------------
FPASuite <http://fpasuite.com.br>
FPASuite <http://fpasuite.com.br>
Copyright © 2013 FPASuite. Todos os direitos reservados