Re: Fastest way to clone schema ~1000x

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Emiel Mols <emiel(at)crisp(dot)nl>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Fastest way to clone schema ~1000x
Date: 2024-02-26 08:50:37
Message-ID: D07A9D78-E3BB-408C-AB87-E41314D52029@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 26 Feb 2024, at 09:46, Emiel Mols <emiel(at)crisp(dot)nl> wrote:

> The 2048 we actually need for our test setup.

There is a measurable overhead in connections, regardless of if they are used
or not. If you are looking to squeeze out performance then doing more over
already established connections, and reducing max_connections, is a good place
to start.

--
Daniel Gustafsson

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emiel Mols 2024-02-26 09:06:31 Re: Fastest way to clone schema ~1000x
Previous Message Emiel Mols 2024-02-26 08:46:11 Re: Fastest way to clone schema ~1000x