Sample Header Ad - 728x90

Advice on postgreSQL table logging

1 vote
0 answers
44 views
I am thinking I can turn off logging for certain tables in my PostgreSQL analytic data warehouse. There are a core set of very large tables (between 50 and 500Gb) that are completely rebuilt at the start of each month. Each table is truncated, identity reset, indexes removed, then reloaded, then reindexed. Once reloaded, the tables are permissioned to select-only and don't get any updates or inserts. Is there any reason for these tables to use the WAL? I should get a performance benefit for the monthly reloads if I turn logging off, and we're not using replication, but I've never used this table option before and want to be sure I'm not missing something important.
Asked by zambo (21 rep)
Nov 29, 2023, 03:53 PM