| From: | Arjen van der Meijden <acmmailing(at)tweakers(dot)net> |
|---|---|
| To: | Cláudia Macedo Amorim <claudia(dot)amorim(at)pcinformatica(dot)com(dot)br> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Problems with + 1 million record table |
| Date: | 2007-10-05 16:38:22 |
| Message-ID: | 4706687E.2000408@tweakers.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2007-10-05 17:45:46 | Re: Problems with + 1 million record table |
| Previous Message | Oleg Bartunov | 2007-10-05 15:32:32 | Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. |