Re: Startup cost of sequential scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Startup cost of sequential scan
Date: 2018-08-30 14:04:55
Message-ID: 5746.1535637895@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2018-08-30 14:09:33 Re: Dimension limit in contrib/cube (dump/restore hazard?)
Previous Message Alexander Kukushkin 2018-08-30 14:03:43 Re: BUG #15346: Replica fails to start after the crash