On Fri, Jul 10, 2020 at 02:10:20AM +0000, tsunakawa.ta...@fujitsu.com wrote: > > There were many proposed patches which help to improve this > > situation. But as far as this patches increase performance only > > at huge servers with large number of cores and show almost no > > improvement (or even some degradation) at standard 4-cores desktops, > > almost none of them were committed. Consequently our customers have > > a lot of troubles trying to replace Oracle with Postgres and provide > > the same performance at same (quite good and expensive) hardware. > > Yeah, it's a pity that the shiny-looking patches from Postgres Pro > (mostly from Konstantin san?) -- autoprepare, built-in connection > pooling, fair lwlock, and revolutionary multi-threaded backend -- > haven't gained hot atension.
Yeah, it is probably time for us to get access to a current large-scale machine again and really find the bottlenecks. We seem to next this every few years. -- Bruce Momjian <br...@momjian.us> https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee