Am Mittwoch, den 11.03.2020, 11:46 -0500 schrieb Jerry Sievers:
> If your site can afford a restart after the bulk load,
>
> 1. Clean shutdown.
> 2. pg_resetwal
> 3. Start
>
> That should leave you with a very small N WAL files, perhaps just 1,
> though I've not run it lately to reverify.
Thank
Hi Justin,
that came to my mind also. Then I tried and found that not always a new WAL is
created. I admit I tried on a test DC with no other transactions going on.
Maybe I should have done that. Anyway, I also always do the checkpoint first
and then the WAL switch, which in my case is also an
Torsten Krah writes:
> Am Mittwoch, den 11.03.2020, 15:45 + schrieb Simon Riggs:
>
>> The size of the task varies, so sometimes takes longer than 60s,
>> depending
>> upon your hardware.
>
> Yes that's what I am observing and why I am asking if there is some
> select statement or command whic
Am Mittwoch, den 11.03.2020, 15:45 + schrieb Simon Riggs:
> The size of the task varies, so sometimes takes longer than 60s,
> depending
> upon your hardware.
Yes that's what I am observing and why I am asking if there is some
select statement or command which triggers that task and returns af
Question everyone isn't this a problem with the order of operations?
switching the wal files then running checkpoint means the Checkpoint can
cross wal files, so the previous wal file can not be deleted???
To my understanding the order operations should be
Checkpoint
which flushes everything
On Wed, 11 Mar 2020 at 08:59, Torsten Krah wrote:
> Hi,
>
> I am building a docker image with a postgresql 12.2 instance and while
> doing so and importing a dump and running some update scripts wal size
> is increasing.
>
> When finished I don't need all those wal files anymore and tried to
> fo
Am Mittwoch, den 11.03.2020, 08:42 -0600 schrieb Michael Lewis:
> I don't know the answer to your stated question. I am curious if you
> have
> set wal_level = minimal and if not, if that would be appropriate for
> your
> use case and might render your concern a non-issue.
Hi Micheal,
I am alread
I don't know the answer to your stated question. I am curious if you have
set wal_level = minimal and if not, if that would be appropriate for your
use case and might render your concern a non-issue.
