pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Almir de Oliveira Duarte Junior <almirjr@adj.com.br>
To: Marc Mamin <M.Mamin@intershop.de>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Slow query help
Date: Thu, 7 Jan 2016 17:30:23 -0200
Message-ID: <568EBCCF.50909@adj.com.br> (raw)
In-Reply-To: <B6F6FD62F2624C4C9916AC0175D56D88420D5B46@jenmbs01.ad.intershop.net>
References: <568DE6D1.4020807@adj.com.br>
	<B6F6FD62F2624C4C9916AC0175D56D88420D5B46@jenmbs01.ad.intershop.net>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

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-per...
>
> 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@adj.com.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

Attachments:


organization_logo_small.png (image/png, 5.2K) download
  view image



organization_business_small_pt.png (image/png, 10.9K) download
  view image

view thread (11+ messages)

Message-ID: <568EBCCF.50909@adj.com.br>
Permalink:  ../568EBCCF.50909@adj.com.br/
Also on:    postgresql.org/message-id/568EBCCF.50909@adj.com.br

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: almirjr@adj.com.br, M.Mamin@intershop.de
  Subject: Re: Slow query help
  In-Reply-To: <568EBCCF.50909@adj.com.br>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox