measuring WAL creation

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема measuring WAL creation
Дата
Msg-id 7058A015-F907-4182-BF9F-9E6904620197@elevated-dev.com
обсуждение исходный текст
Ответы Re: measuring WAL creation
Список 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
thegenerated 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
Ican 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@elevated-dev.com
https://www.linkedin.com/in/scottribe/






В списке pgsql-admin по дате отправления: