seq scan startup cost

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: seq scan startup cost
Date: 2002-01-10 11:14:31
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA41EB49B@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Imho the simplification, that seq scan startup cost is 0.0 is
only valid when we expect to return most of the rows.

When expecting only 1 row, imho the costs need to be 50 % for
startup and 50 % rest. Assuming, that on average the row will be
in the middle of that relation file.
When returning 10% of the rows startup would be 10 % ...

The reasoning beeing, that you need to read a few pages before you
find the first match.

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Kalchev 2002-01-10 11:37:41 Re: again on index usage
Previous Message Zeugswetter Andreas SB SD 2002-01-10 10:55:20 Re: again on index usage