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

help / color / mirror / Atom feed

From: Arjen van der Meijden <acmmailing@tweakers.net>
To: Cláudia Macedo Amorim <claudia.amorim@pcinformatica.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: Problems with + 1 million record table
Date: Fri, 05 Oct 2007 18:38:22 +0200
Message-ID: <4706687E.2000408@tweakers.net> (raw)
In-Reply-To: <002001c8075c$c9736df0$9fc8a8c0@pcserver.pcinformatica.com.br>
References: <002001c8075c$c9736df0$9fc8a8c0@pcserver.pcinformatica.com.br>

On 5-10-2007 16:34 Cláudia Macedo Amorim wrote:
> [13236.470]                 statement_type=0, statement='select
> a_teste_nestle."CODCLI",
> a_teste_nestle."CODFAB",
> a_teste_nestle."CODFAMILIANESTLE",
> a_teste_nestle."CODFILIAL",
> a_teste_nestle."CODGRUPONESTLE",
> a_teste_nestle."CODSUBGRUPONESTLE",
> a_teste_nestle."CONDVENDA",
> a_teste_nestle."DATA",
> a_teste_nestle."DESCRICAO",
> a_teste_nestle."PESO",
> a_teste_nestle."PRACA",
> a_teste_nestle."PUNIT",
> a_teste_nestle."PVENDA",
> a_teste_nestle."QT",
> a_teste_nestle."QTITVENDIDOS",
> a_teste_nestle."QTPESOPREV",
> a_teste_nestle."QTVENDAPREV",
> a_teste_nestle."SUPERVISOR",
> a_teste_nestle."VENDEDOR",
> a_teste_nestle."VLVENDAPREV"
> from a_teste_nestle
>  
> '

Is that the entire query? Are you sure you really want to select the 
entire table without having a where-clause? That's normally not a very 
scalable aproach...

Best regards,

Arjen

view thread (5+ messages)  latest in thread

Message-ID: <4706687E.2000408@tweakers.net>
Permalink:  ../4706687E.2000408@tweakers.net/
Also on:    postgresql.org/message-id/4706687E.2000408@tweakers.net

copy link · copy postgr.es

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: acmmailing@tweakers.net, claudia.amorim@pcinformatica.com.br
  Subject: Re: Problems with + 1 million record table
  In-Reply-To: <4706687E.2000408@tweakers.net>

* 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