measuring WAL creation

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: measuring WAL creation
Date: 2024-08-02 19:16:06
Message-ID: 7058A015-F907-4182-BF9F-9E6904620197@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'd like to measure both the amount of WAL created by a long series of data modifications and the compressed size of the generated WAL files.

I suppose I need to set wal_keep_size high, and pay attention to segment numbers to make sure it was high enough. Then I can look at segments created while the commands were running.

But question: can I simply delete all WAL after a clean shutdown?

--
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 Tom Lane 2024-08-02 20:29:19 Re: measuring WAL creation
Previous Message khan Affan 2024-07-31 07:33:47 Re: DR setup in RHOS