select * from a 3M-row table very slow

From: Jessica Richard <rjessil(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: select * from a 3M-row table very slow
Date: 2007-07-02 14:23:29
Message-ID: 265346.45901.qm@web56405.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Alvão Carvalho Júnior 2007-07-02 14:31:05 Re: select * from a 3M-row table very slow
Previous Message Jayakumar_Mukundaraju 2007-07-02 13:51:36 pg_hba.conf issue