INSERT using multiple cores (inspired by COPY from CSV in LOCKED mode)

Anton Kravchenko kravchenko.anton86 at gmail.com
Thu Apr 12 18:51:52 CEST 2018


Hi there,

1) It looks like INSERTing into tables is bounded by a single CPU.
And it kills performance of a query that normally uses multiple CPUs...

CREATE TEMP TABLE t1 AS
(some 'select query' that uses multiple cores when run standalone)
ON COMMIT PRESERVE ROWS;
or
INSERT into t1 (some 'select query' that uses multiple cores when run
standalone);

2) Do you think you could implement INSERT with LOCKED option?
(like it was done for COPY from CSV in LOCKED mode)

Please let me know whether you think it's doable.

Thank you,
Anton
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20180412/b299520f/attachment.html>


More information about the developers-list mailing list