[ 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)