Re: Startup cost of sequential scan - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Startup cost of sequential scan
Date
Msg-id 5746.1535637895@sss.pgh.pa.us
Whole thread Raw
In response to Startup cost of sequential scan  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Responses Re: Startup cost of sequential scan
Re: Startup cost of sequential scan
List pgsql-hackers
Alexander Korotkov <a.korotkov@postgrespro.ru> writes:
> But I think there is another issue in sequential scan cost.  We have
> zero startup cost for sequential scan.  But why?

Because it's what the mental model of startup cost says it should be.
Also, I do not think we can change that without a whole lot of unpleasant
side effects on cases that work well today.  Have you even checked to
see how much of the regression tests break with this change?

            regards, tom lane


pgsql-hackers by date:

Previous
From: Alexander Kukushkin
Date:
Subject: Re: BUG #15346: Replica fails to start after the crash
Next
From: Alexander Korotkov
Date:
Subject: Re: Dimension limit in contrib/cube (dump/restore hazard?)