Re: WAL settings for larger imports

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Benoit, Eric" <ebenoit(at)e1b(dot)org>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: WAL settings for larger imports
Date: 2024-06-17 15:10:11
Message-ID: e46fdfe4-8eeb-4ff1-89c3-275fe6123550@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/17/24 06:46, Benoit, Eric wrote:
> What is a good data import configuration for only one server for
> WRITE-AHEAD LOG settings postgresql.conf where no one is connecting to
> the database accept me as a superuser.

1) The Confidentiality Notice is longer then the question and is
basically pointless.

2) An answer is going to need more information:

a) Postgres version?

b) What are your current settings?

c) What constitutes a 'larger import'?

d) How often are you doing these imports?

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-06-17 15:57:30 Re: WAL settings for larger imports
Previous Message Benoit, Eric 2024-06-17 13:46:06 WAL settings for larger imports