Re: A cost issue in ORDER BY + LIMIT

From: Zhang Mingli <zmlpostgres(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org, Paul Guo <paulguo(at)gmail(dot)com>
Subject: Re: A cost issue in ORDER BY + LIMIT
Date: 2022-08-06 15:48:55
Message-ID: 447a7d6f-bac1-45c1-ab42-eceedeb8d789@Spark
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

HI,

What if the the rows of t1 is less than the limit number(ex: t1 has 5 rows, limit 10)?
Does it matter?

Regards,
Zhang Mingli
On Aug 6, 2022, 23:38 +0800, Paul Guo <paulguo(at)gmail(dot)com>, wrote:
>
> limit_tuples

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-08-06 15:59:04 Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints
Previous Message Paul Guo 2022-08-06 15:38:17 A cost issue in ORDER BY + LIMIT