AW: SourceForge & Postgres - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: SourceForge & Postgres
Date
Msg-id 11C1E6749A55D411A9670001FA687963368179@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> > anyway? ;-))  If so, a search for artistid 100050450 definitely *should*
> > use a sequential scan.
> 
> I tested this statement against the database and you are right, about 14
> seconds with the index, 4 without.

Now I don't understand the problem any more. Are you complaining, that
the optimizer is choosing a faster path ? Or are you saying, that you also
get the seq scan for other very infrequent values ?

Andreas


pgsql-hackers by date:

Previous
From: Fabio Nanni
Date:
Subject: triggers and actions tree/2
Next
From: tolik@aaanet.ru (Anatoly K. Lasareff)
Date:
Subject: Locale and multibyte support in 7.1