Re: High COMMIT times

Поиск
Список
Период
Сортировка
От Joshua Drake
Тема Re: High COMMIT times
Дата
Msg-id CAJvJg-SUfe+Fv0JmvBWgyaPx=J9dzEk9Bg=4JheuVwAdNMj6HA@mail.gmail.com
обсуждение исходный текст
Ответ на High COMMIT times  (Don Seiler <don@seiler.us>)
Ответы Re: High COMMIT times  (Don Seiler <don@seiler.us>)
Список pgsql-performance
I have the stats_temp_directory in a tmpfs mount. I do have pg_wal on the same premium SSD storage volume as the data directory. Normally I would know to separate these but I was told with the cloud storage that it's all virtualized anyway, plus storage IOPS are determined by disk size so having a smaller volume just for pg_wal would hurt me in this case. The kind folks in the PG community Slack suggested just having one large premium cloud storage mount for 
the data directory and leave pg_wal inside because this virtualization removes any guarantee of true separation.

It is true that the IO is virtualized but that does not mean that separate volumes won't help. In cloud storage you are granted specific IOPS/MB/s per volume. Separating pg_wal to a new volume mount will take pressure off of page writes and allow the wal to write within its own prioritization.

JD

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

Предыдущее
От: Don Seiler
Дата:
Сообщение: High COMMIT times
Следующее
От: Don Seiler
Дата:
Сообщение: Re: High COMMIT times