[MCOL-3866] insert into select performance slow on 1.4 release Created: 2020-03-03  Updated: 2021-04-19  Resolved: 2021-01-16

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.4.2
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Roman
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

We have a 1.4.2 Columnstore instance running with 1 UM and 4 PM separate nodes. We have a routine process that runs an 'insert into .. select' statement with a larger query.. results are about 3.2 million rows to insert. This is being run on our 1.2.5 instance, and can complete in around 1 minute. WHen running this on our 1.4.2 instance, it does not seem to ever complete when letting it run. The select portion will complete on it's own in about a minute as expected, however the insert into seems to be taking a very long time.. in fact I have yet to see it actually finish.



 Comments   
Comment by Todd Stoffel (Inactive) [ 2021-01-16 ]

Obsoleted by newer versions.

Generated at Thu Feb 08 02:46:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.