Home > mailing lists

Re: Why sequential scan with index present? - Mailing list pgsql-cygwin

From	Michael Labhard
Subject	Re: Why sequential scan with index present?
Date	August 31, 2002 15:29:52
Msg-id	akqqr5$ohl$1@main.gmane.org Whole thread Raw
In response to	Why sequential scan with index present? ("Michael Labhard" <ince@pacifier.com>)
List	pgsql-cygwin

Found answer somewhere on PostgreSQL web site:  optimizer uses sequential
scan anyway if the number of records are small.

-- Michael

From: Jason Tishler
Date: 30 August 2002, 18:39:45
Subject: Re: PG on Win2K

From: "Michael Labhard"
Date: 31 August 2002, 17:49:52
Subject: PostgreSQL unsuitable for large datasets?