Home > mailing lists

select * from a 3M-row table very slow - Mailing list pgsql-admin

From	Jessica Richard
Subject	select * from a 3M-row table very slow
Date	July 2, 2007 14:30:17
Msg-id	265346.45901.qm@web56405.mail.re3.yahoo.com Whole thread Raw
List	pgsql-admin

Tree view

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.

pgsql-admin by date:

From: "Jayakumar_Mukundaraju"
Date: 02 July 2007, 14:04:35
Subject: pg_hba.conf issue

From: Daniel Alvão Carvalho Júnior
Date: 02 July 2007, 14:38:47
Subject: Re: select * from a 3M-row table very slow

select * from a 3M-row table very slow - Mailing list pgsql-admin

Previous

Next