Re: question about seq scan and index scan

From: Hervé Piedvache <herve(at)elma(dot)fr>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: Sébastien PALLEAU <spalleau(at)elma(dot)fr>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: question about seq scan and index scan
Date: 2002-10-26 13:19:52
Message-ID: 20021026132243.4E8E741802@mailer.elma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le Vendredi 25 Octobre 2002 20:17, Stephan Szabo a écrit :
> On Fri, 25 Oct 2002, [iso-8859-15] Hervé Piedvache wrote:
> > Thanks for you help ... to "explain" us why Postgresql do not use all the
> > time the index scan for this kind of request for 3 tables with the same
> > primary key id.
>
> Depending on the number of rows returned, index scan may not be faster
> than a sequential scan. As you up the constant, the estimated number of
> rows drops which make the index scan a better and better plan. Are
> the estimated number of rows for the scan of a (4379, 3987, and 29)
> realistic for mynumber>(23000, 23500, 24000)

I'm surpise about this answer for

>23000
result is 98

>23350
result is 96

>24000
result is 93

With a table of 471 413 records and most of the values for mynumber are
< of 2500 result is 467 902 records ...

I do not understand the explain result sorry ! ;o/

Regards,
--
Hervé Piedvache

Elma Ingénierie Informatique
6 rue du Faubourg Saint-Honoré
F-75008 - Paris - France
Tel. 33-144949901
fax. 33-144949902

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-10-26 14:21:20 Re: GROUP BY array
Previous Message Stephen J. Thompson 2002-10-26 10:53:30 Two Phase Commit support