Postgres performance analysis resulted in a 10x improvement in CPU use
I'm a little disappointed the answer was "batch inserts"This is write performance optimization 101. I bet you are getting wins in way more places in the pipeline than the evaluation pointed to by doing this.Try doing the same optimization on a table with zero partial indexes and you will get the same 10x bump. It is better for many many reasons.Still, super cool dig into performance tools and source code. It shows great aptitude and willingness to deep dive.