q re removal/recycling of WAL files

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: q re removal/recycling of WAL files
Date: 2021-11-03 22:24:18
Message-ID: 4B485D8E-9692-4009-8562-43BC0E54C975@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Let's say that there's a big update as part of a migration, and that update times out, and the migration utility retries it several times. (Context is that sequence happened through automated utility, and filled the disk, leading to an unfortunate series of events.)

1) At what point does WAL from the failed & rolled back operations "go away"? During the next checkpoint? During the checkpoint after completion of all other transactions which overlapped time-wise with the timing-out ones?

2) Is there a chance that never-visible rows would be written into tables, bloating them?

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
https://www.linkedin.com/in/scottribe/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rui DeSousa 2021-11-03 23:37:45 Re: q re removal/recycling of WAL files
Previous Message Marc Fromm 2021-11-03 21:03:28 Encoding error during database restore