Seqscan

From: Adrian Demaestri <ademaestri(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Seqscan
Date: 2007-10-23 02:24:39
Message-ID: 853733.8751.qm@web50901.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,
I think planner should use other plans than seqscan to solve querys like select * from hugetable limit 1, especially when the talbe is very large. Is it solved in newer versions or is there some open issues about it?.
thanks
I'm working with postgres 8.0.1,

---------------------------------

¡Sé un mejor fotógrafo!
Perfecciona tu técnica y encuentra las mejores fotos en:
http://telemundo.yahoo.com/promos/mejorfotografo.html

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Davis 2007-10-23 02:45:11 Re: Seqscan
Previous Message Kevin Grittner 2007-10-22 17:34:06 Re: Memory Settings....