On Fri, Jan 31, 2020 at 11:05 PM Nicola Contu <nicola.contu@gmail.com> wrote:
> Do you still recommend to increase max_conn?
Yes, as a workaround of last resort. The best thing would be to
figure out why you are hitting the segment limit, and see if there is
something we could tune to fix that. If you EXPLAIN your queries, do
you see plans that have a lot of "Gather" nodes in them, perhaps
involving many partitions? Or are you running a lot of parallel
queries at the same time? Or are you running queries that do very,
very large parallel hash joins? Or something else?