[
https://issues.apache.org/jira/browse/CASSANDRA-18796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17794869#comment-17794869
]
Stefan Miklosovic edited comment on CASSANDRA-18796 at 12/8/23 9:56 PM:
------------------------------------------------------------------------
Thanks [~maedhroz] for the review, I think we are almost there and we figured
everything out. I just need to spend a little bit more time on tests. I will
get back to this for sure until the end of the year.
was (Author: smiklosovic):
Thanks [~maedhroz] for the review, I think we are almost there and we figured
everything out. I just need to spend a little bit more time on tests. I will
get back to this in for sure until end of the year.
> Optionally fail when a non-partition-restricted query is issued against a
> storage-attached index
> ------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-18796
> URL: https://issues.apache.org/jira/browse/CASSANDRA-18796
> Project: Cassandra
> Issue Type: Improvement
> Components: Feature/2i Index, Feature/SAI, Local/Compaction/LCS
> Reporter: Caleb Rackliffe
> Assignee: Stefan Miklosovic
> Priority: Normal
> Fix For: 5.0-rc, 5.x
>
> Time Spent: 9h
> Remaining Estimate: 0h
>
> With LCS, we will have potentially thousands of SSTables for a given user
> table. Storage-attached also means SSTable-attached, and searching thousands
> of attached indexes is not going to scale well at all locally, due to the
> sheer number of searches and amount of postings list merging involved. We
> should have a guardrail to prohibit this by default.
> Partition-restricted queries, the use-case SAI is broadly designed for,
> should be very efficient.
> UPDATE: The consensus from the discussion below is that we'll add two
> guardrails here. One is simply for whether we'll allow
> non-partition-restricted 2i queries. The other is a warn/fail threshold pair
> for the number of SSTable indexes read locally on a query.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
