RisingWave Community - Does RisingWave support any form of partitioning?

all-things-risingwave

Does RisingWave support any form of partitioning?

One of our use cases is an event store with billions of records that consume a few TB of disk space. We only need to perform queries on a relatively small subset of records related to some online classroom. How can we optimize read queries for large tables in RisingWave?

An

Andrei Nesterov

Asked on Jun 28, 2023

RisingWave supports partitioning of data, and point/prefix SELECT is very efficient.
You can create indexes to speed up certain queries.
Compacting data into partitions can reduce the number of requests to S3.
For more information on creating indexes in RisingWave, you can refer to the documentation at SQL Create Index

Jun 28, 2023Edited by