Re: Postgresql Database and PG_WAL locations

Поиск
Список
Период
Сортировка
От Matthew Tice
Тема Re: Postgresql Database and PG_WAL locations
Дата
Msg-id 5BDE97CE-242C-479A-BDC7-CF263BBD554B@gmail.com
обсуждение исходный текст
Ответ на Postgresql Database and PG_WAL locations  (Henry Ashu <henry.ashu@dat.com>)
Ответы Re: Postgresql Database and PG_WAL locations
Список pgsql-admin
Дерево обсуждения


On Aug 29, 2024, at 12:18 PM, Henry Ashu <henry.ashu@dat.com> wrote:

I have a database that's about 2TB in size, and I want to place the database files in a separate mount point(PGDATA) and the log files in a different mount point(PG_WAL). What's your take on this?.



Essentially, yes, you will want your WAL and data stored on different devices (or the very least, different partitions).

Thank you

Henry Ashu

Database Administrator
o: 503.672.5114 | f: 800.551.8821 | DAT.com

DAT Solutions    Like us on Facebook  Follow us on Twitter  Connect with us on LinkedIn  Visit our YouTube Channel  Visit us on Instagram

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