Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 2B9A89FBABE
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri,  5 Oct 2007 13:38:26 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 60457-09 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri,  5 Oct 2007 13:38:20 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from olive.qinip.net (olive.qinip.net [62.100.30.40])
	by postgresql.org (Postfix) with ESMTP id EAB779FB330
	for <pgsql-performance@postgresql.org>;
	Fri,  5 Oct 2007 13:38:21 -0300 (ADT)
Received: from [10.0.0.21] (h8441139206.dsl.speedlinq.nl [84.41.139.206])
	by olive.qinip.net (Postfix) with ESMTP id 0A789188ED;
	Fri,  5 Oct 2007 18:38:24 +0200 (MEST)
Message-ID: <4706687E.2000408@tweakers.net>
Date: Fri, 05 Oct 2007 18:38:22 +0200
From: Arjen van der Meijden <acmmailing@tweakers.net>
User-Agent: Thunderbird 2.0.0.6 (Windows/20070728)
MIME-Version: 1.0
To: =?ISO-8859-1?Q?Cl=E1udia_Macedo_Amorim?=
	<claudia.amorim@pcinformatica.com.br>
CC: pgsql-performance@postgresql.org
Subject: Re: Problems with + 1 million record table
References: <002001c8075c$c9736df0$9fc8a8c0@pcserver.pcinformatica.com.br>
In-Reply-To: <002001c8075c$c9736df0$9fc8a8c0@pcserver.pcinformatica.com.br>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200710/59
X-Sequence-Number: 27081

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