On Mon, 8 Apr 2019 at 14:54, Tsunakawa, Takayuki <tsunakawa.ta...@jp.fujitsu.com> wrote: > > From: 'Andres Freund' [mailto:and...@anarazel.de] > > Did you see that people measured slowdowns? > > Yeah, 0.5% decrease with pgbench -M prepared -S (select-only), which feels > like a somewhat extreme test case. And that might be within noise as was > mentioned. > > If we want to remove even the noise, we may have to think of removing the > LocalLockHash completely. But it doesn't seem feasible...
It would be good to get your view on the shrink_bloated_locallocktable_v3.patch I worked on last night. I was unable to measure any overhead to solving the problem that way. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services