Re: Query Planner not taking advantage of HASH PARTITION

2022-04-21 Thread Justin Pryzby
On Wed, Apr 20, 2022 at 07:11:37PM -0700, Benjamin Tingle wrote: > @ the first point about write locks > I think I had/have a misconception about how inserts work in postgres. It's > my understanding that postgres will never draft a parallel insert plan for > any query (except maybe CREATE TABLE AS

Re: Query Planner not taking advantage of HASH PARTITION

2022-04-21 Thread Benjamin Tingle
Going to forward my response from an individual thread with Jeff here in case anyone else can help me out. I wasn't sure if forwarding the message to the mailing list would be considered as a continuation of the same subject, so I'm just going to paste it here. I'm a bit of an email noob :P -