Home > mailing lists

Re: LIMIT clause extremely slow - Mailing list pgsql-bugs

From	Christophe Pettus
Subject	Re: LIMIT clause extremely slow
Date	November 15, 2023 20:48:37
Msg-id	23678F58-FF60-4A9E-A975-A7AA65784A00@thebuild.com Whole thread Raw
In response to	LIMIT clause extremely slow ("Melzer Kassensysteme" <office@melzer-kassen.com>)
List	pgsql-bugs

Tree view


> On Nov 15, 2023, at 08:46, Melzer Kassensysteme <office@melzer-kassen.com> wrote:
>
> SELECT * FROM table WHERE (index1 > 1 OR (index1 = 1 AND index2 > 5)) ORDER BY index1, index2 LIMIT 1

Can you show the output of the query running under EXPLAIN ANALYZE ... ?

pgsql-bugs by date:

From: Laurenz Albe
Date: 15 November 2023, 20:23:08
Subject: Re: BUG #18200: Undefined behaviour in interval_div

From: Laurenz Albe
Date: 15 November 2023, 20:48:47
Subject: Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows

Re: LIMIT clause extremely slow - Mailing list pgsql-bugs

Previous

Next