citusdata / citusdata/citus

Limit ... offset... and pagination performance

Open
#6,522 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

When create distributed table and implement paging query with limit ... offset ... , it is about 10x slower than the single postgresql under the ten million level data volume. Is there a better solution to improve paging query performance?

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.