[jira] [Updated] (KUDU-2076) Deleting/updating is slow on single numeric row key tables
[ https://issues.apache.org/jira/browse/KUDU-2076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Grant Henke updated KUDU-2076: -- Labels: performance (was: ) > Deleting/updating is slow on single numeric row key tables > -- > > Key: KUDU-2076 > URL: https://issues.apache.org/jira/browse/KUDU-2076 > Project: Kudu > Issue Type: Bug > Components: perf, tablet >Affects Versions: 1.4.0 >Reporter: Jean-Daniel Cryans >Priority: Major > Labels: performance > > A user reported that deleting 50M rows on the simplest of tables, (id INT, > text STRING, PRIMARY KEY (id)), doesn't complete. > It reproduces locally and I was able to see that we're deleting 1.4 rows / ms > which is awful considering that everything is cached. > Todd found that we're spending most of our time decoding big blocks of > bit-shuffled keys. Intuitively he though that having a composite row key > would perform better and indeed adding a column set to 0 in front makes it > 10x faster. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (KUDU-2076) Deleting/updating is slow on single numeric row key tables
[ https://issues.apache.org/jira/browse/KUDU-2076?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Grant Henke updated KUDU-2076: -- Component/s: perf > Deleting/updating is slow on single numeric row key tables > -- > > Key: KUDU-2076 > URL: https://issues.apache.org/jira/browse/KUDU-2076 > Project: Kudu > Issue Type: Bug > Components: perf, tablet >Affects Versions: 1.4.0 >Reporter: Jean-Daniel Cryans >Priority: Major > > A user reported that deleting 50M rows on the simplest of tables, (id INT, > text STRING, PRIMARY KEY (id)), doesn't complete. > It reproduces locally and I was able to see that we're deleting 1.4 rows / ms > which is awful considering that everything is cached. > Todd found that we're spending most of our time decoding big blocks of > bit-shuffled keys. Intuitively he though that having a composite row key > would perform better and indeed adding a column set to 0 in front makes it > 10x faster. -- This message was sent by Atlassian Jira (v8.3.4#803005)