Обсуждение: select * from a 3M-row table very slow

Is there anything that can make this faster? Is there any memory config (postgres and OS) that can be tuned? it came back very quick under Informix.
Thanks.

---

Looking for earth-friendly autos?
Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

Hi !
Tell us your hardware and software configurations.
[]s


> ----- Original Message -----
> From: "Jessica Richard" <rjessil@yahoo.com>
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] select * from a 3M-row table very slow
> Date: Mon, 2 Jul 2007 07:23:29 -0700 (PDT)
>
>
> Is there anything that can make this faster? Is there any memory
> config (postgres and OS) that can be tuned? it came back very quick
> under Informix.
> Thanks.
>
>
> ---------------------------------
> Looking for earth-friendly autos?
>   Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

>


=


--
Powered by Outblaze

Please, send your query, table definition and indexes and the execution plan.

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Daniel Alvão Carvalho
Júnior
Sent: segunda-feira, 2 de julho de 2007 11:31
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] select * from a 3M-row table very slow

Hi !
Tell us your hardware and software configurations.
[]s


> ----- Original Message -----
> From: "Jessica Richard" <rjessil@yahoo.com>
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] select * from a 3M-row table very slow
> Date: Mon, 2 Jul 2007 07:23:29 -0700 (PDT)
>
>
> Is there anything that can make this faster? Is there any memory
> config (postgres and OS) that can be tuned? it came back very quick
> under Informix.
> Thanks.
>
>
> ---------------------------------
> Looking for earth-friendly autos?
>   Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

>


=


--
Powered by Outblaze

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster