3 ms·
Parallell insert. I can easily saturate a CPU with insert statements, with io very low.
by hyperman1 1y ago
Parallell insert. I can easily saturate a CPU with insert statements, with io very low.
- DumBthInker007 1y agoHi thanks for the reply ,i guess there was some ongoing work for this and for some reason it didn't continued this is the thread https://www.postgresql.org/message-id/flat/CAJcOf-cXnB5cnMKqWEp2E2z7Mvcd04iLVmV%3DqpFJrR3AcrTS3g%40mail.gmail.com https://www.postgresql.org/message-id/flat/CAJcOf-cXnB5cnMKq... if you are interested in, but for sure i will look into this(added to my list:).
- hyperman1 1y agoWhat can I say, except thank you very much.
- dapperdrake 1y agoThat seems like an unintuitive consequence. Saturating disk would have been obvious. But CPU? Does anything about the INSERT pattern seem "special"? Or does it happen for many different "kinds of INSERT statements"?