| From: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
|---|---|
| To: | Almir de Oliveira Duarte Junior <almirjr(at)adj(dot)com(dot)br>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Slow query help |
| Date: | 2016-01-07 19:15:41 |
| Message-ID: | B6F6FD62F2624C4C9916AC0175D56D88420D5B46@jenmbs01.ad.intershop.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Almir de Oliveira Duarte Junior | 2016-01-07 19:30:23 | Re: Slow query help |
| Previous Message | Rafael Bernard Rodrigues Araujo | 2016-01-07 18:55:27 | Re: Slow query help |