Re: Tuning a query with ORDER BY and LIMIT

From: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Tuning a query with ORDER BY and LIMIT
Date: 2022-06-22 22:25:58
Message-ID: 20220622222558.2giv6yefxffswdwq@hjp.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2022-06-23 00:19:19 +0200, Peter J. Holzer wrote:
> On 2022-06-22 23:48:37 +0200, Peter J. Holzer wrote:
> > The index cannot be used for sorting, since the column used for sorting
> > isn't in the first position in the index.
>
> compared to a single value
^ not

E-Mail really needs a "Supercedes" header.

hp

--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2022-06-22 23:22:13 Re: Tuning a query with ORDER BY and LIMIT
Previous Message Zheng Li 2022-06-22 22:22:00 Re: Support logical replication of DDLs