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...

(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