[Beginner Question] Will the backup wal file take too much storage space?

From: Wen Yi <896634148(at)qq(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: [Beginner Question] Will the backup wal file take too much storage space?
Date: 2023-06-13 08:00:37
Message-ID: tencent_4628EAB456FD4C97206DE368DDE0A4D95C09@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi community,
When I learn the wal log, a question confuse me.
As you can see, base on the wal, we can restore the database to any check point, but sometimes, If we insert a large column to the postgres (Up to 1 GB), the postgres will also create a 1 GB wal to store it.
In this situation, will the backup wal file take too much storage space?

Thanks in advance!

Yours,
Wen Yi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Devienne 2023-06-13 08:17:27 "paths" between two ROLEs
Previous Message Michael Paquier 2023-06-13 07:50:54 Re: Support logical replication of DDLs