To reproduce

Let's consider the following trips table query from demo:

select distinct cab_type, vendor_id, pickup_datetime from trips order by pickup_datetime desc limit 100;

Its explain plan is the following.

Here, LimitedSizeSortedLightRecordCursorFactory is applied on top of DistinctTimeSeriesRecordCursorFactory which means that LimitedSizeSortedLightRecordCursor#buildChain() iterates through full DistinctTimeSeriesRecordCursorFactory's result set. Instead, we should stop as soon as we got 100 rows.

QuestDB version:

7.3.9

OS, in case of Docker specify Docker and the Host OS:

Linux

File System, in case of Docker specify Host File System:

ext4

Full Name:

Andrei Pechkurov

Affiliation:

QuestDB

Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?

• Yes, I have

Additional context

No response