Postgres Pro
Downloads
Home   >   mailing lists

Re: Fastest way to clone schema ~1000x - Mailing list pgsql-general

From Daniel Gustafsson
Subject Re: Fastest way to clone schema ~1000x
Date
Msg-id D07A9D78-E3BB-408C-AB87-E41314D52029@yesql.se
Whole thread Raw
In response to Re: Fastest way to clone schema ~1000x  (Emiel Mols <emiel@crisp.nl>)
Responses Re: Fastest way to clone schema ~1000x  (Emiel Mols <emiel@crisp.nl>)
List pgsql-general
Tree view 
> On 26 Feb 2024, at 09:46, Emiel Mols <emiel@crisp.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

pgsql-general by date:

Previous
From: Emiel Mols
Date:
Subject: Re: Fastest way to clone schema ~1000x
Next
From: Emiel Mols
Date:
Subject: Re: Fastest way to clone schema ~1000x