INSERT using multiple cores (inspired by COPY from CSV in LOCKED mode)
kravchenko.anton86 at gmail.com
Thu Apr 12 18:51:52 CEST 2018
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;
INSERT into t1 (some 'select query' that uses multiple cores when run
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.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the developers-list