Postgres performance analysis resulted in a 10x improvement in CPU use
I'm a little disappointed the answer was "batch inserts"<p>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.<p>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.<p>Still, super cool dig into performance tools and source code. It shows great aptitude and willingness to deep dive.