You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Let's consider the following trips table query from demo:
select distinct cab_type, vendor_id, pickup_datetime from trips order by pickup_datetime desclimit100;
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
The text was updated successfully, but these errors were encountered:
To reproduce
Let's consider the following
trips
table query from demo:Its explain plan is the following.
Here,
LimitedSizeSortedLightRecordCursorFactory
is applied on top ofDistinctTimeSeriesRecordCursorFactory
which means thatLimitedSizeSortedLightRecordCursor#buildChain()
iterates through fullDistinctTimeSeriesRecordCursorFactory
'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?
Additional context
No response
The text was updated successfully, but these errors were encountered: