pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: alemon@tiago.hazor.com.br
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: slow database
Date: Wed, 11 Feb 2004 16:18:35 -0200
Message-ID: <1076523515.402a71fb8b30e@tiago.hazor.com.br> (raw)
In-Reply-To: <Pine.LNX.4.33.0402111047140.343-100000@css120.ihs.com>
References: <Pine.LNX.4.33.0402111047140.343-100000@css120.ihs.com>

the version is 7.3.2 in a connective 9.
the hen foot is without nails at the moment: =)
 |
/|\

this is a principal table of system:

CREATE TABLE public.compra_prod_forn
(
  nu_seq_prod_forn numeric(12) NOT NULL,
  cd_fabricante numeric(6),
  cd_moeda numeric(4) NOT NULL,
  cd_compra numeric(12) NOT NULL,
  cd_produto numeric(9),
  cd_fornecedor numeric(6),
  cd_incotermes numeric(3) NOT NULL,
  qtde_compra numeric(12,3),
  perc_comissao_holding numeric(5,2),
  vl_cotacao_unit_negociacao numeric(20,3),
  dt_retorno date,
  cd_status_cv numeric(3) NOT NULL,
  cd_usuario numeric(6) NOT NULL,
  tp_comissao varchar(25),
  vl_pif numeric(9,2),
  cd_fornecedor_contato numeric(6),
  cd_contato numeric(6),
  cd_un_peso varchar(20),
  vl_currier numeric(9,2),
  cd_iqf numeric(3),
  cd_un_peso_vl_unit varchar(10),
  dt_def_fornecedor date,
  vl_cotacao_unit_forn numeric(20,3),
  vl_cotacao_unit_local numeric(20,3),
  tp_vl_cotacao_unit numeric(1),
  cd_moeda_forn numeric(4),
  cd_moeda_local numeric(4),
  vl_cotacao_unit numeric(20,3),
  peso_bruto_emb varchar(20),
  id_fax numeric(1),
  id_email numeric(1),
  fob varchar(40),
  origem varchar(40),
  tipo_comissao varchar(40),
  descr_fabricante_select varchar(200),
  farmacopeia varchar(100),
  vl_frete numeric(10,3),
  descr_abandono_representada varchar(2000),
  descr_abandono_interno varchar(2000),
  vl_frete_unit numeric(10,3),
  CONSTRAINT compra_prod_forn_pkey PRIMARY KEY (cd_compra, nu_seq_prod_forn),
  CONSTRAINT "$1" FOREIGN KEY (cd_moeda_local) REFERENCES public.moeda 
(cd_moeda) ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT "$10" FOREIGN KEY (cd_usuario) REFERENCES public.usuario_sistema 
(cd_usuario) ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT "$11" FOREIGN KEY (cd_status_cv) REFERENCES 
public.status_compra_venda (cd_status_cv) ON UPDATE NO ACTION ON DELETE NO 
ACTION,
  CONSTRAINT "$12" FOREIGN KEY (cd_moeda) REFERENCES public.moeda (cd_moeda) ON 
UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT "$2" FOREIGN KEY (cd_moeda_forn) REFERENCES public.moeda 
(cd_moeda) ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT "$3" FOREIGN KEY (cd_un_peso_vl_unit) REFERENCES 
public.unidades_peso (cd_un_peso) ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT "$4" FOREIGN KEY (cd_un_peso) REFERENCES public.unidades_peso 
(cd_un_peso) ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT "$5" FOREIGN KEY (cd_fornecedor_contato, cd_contato) REFERENCES 
public.fornecedor_contato (cd_fornecedor, cd_contato) ON UPDATE NO ACTION ON 
DELETE NO ACTION,
  CONSTRAINT "$6" FOREIGN KEY (cd_fabricante) REFERENCES public.fabricante 
(cd_fabricante) ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT "$7" FOREIGN KEY (cd_produto, cd_fornecedor) REFERENCES 
public.fornecedor_produto (cd_produto, cd_fornecedor) ON UPDATE NO ACTION ON 
DELETE NO ACTION,
  CONSTRAINT "$8" FOREIGN KEY (cd_incotermes) REFERENCES public.incotermes 
(cd_incotermes) ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT "$9" FOREIGN KEY (cd_compra) REFERENCES public.compra (cd_compra) 
ON UPDATE NO ACTION ON DELETE CASCADE
) WITH OIDS;



Quoting "scott.marlowe" <scott.marlowe@ihs.com>:

> On Wed, 11 Feb 2004 alemon@tiago.hazor.com.br wrote:
> 
> > I already came back the old conditions and I continue slow in the same
> > way!
> 
> OK, we need some things from you to help troubleshoot this problem.
> 
> Postgresql version
> schema of your tables
> output of "explain analyze your query here"
> a chicken foot (haha, just kidding. :-)
> 
> 






view thread (16+ messages)  latest in thread

Message-ID: <1076523515.402a71fb8b30e@tiago.hazor.com.br>
Permalink:  ../1076523515.402a71fb8b30e@tiago.hazor.com.br/
Also on:    postgresql.org/message-id/1076523515.402a71fb8b30e@tiago.hazor.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: alemon@tiago.hazor.com.br, scott.marlowe@ihs.com, tgl@sss.pgh.pa.us
  Subject: Re: slow database
  In-Reply-To: <1076523515.402a71fb8b30e@tiago.hazor.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