Re: WAL directory size calculation

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: WAL directory size calculation
Дата
Msg-id 6dac18df-2926-f030-fcd9-55d0178dcb2d@a-kretschmer.de
обсуждение исходный текст
Ответ на WAL directory size calculation  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Ответы Re: WAL directory size calculation  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Re: WAL directory size calculation  (Jan Wieck <jan@wi3ck.info>)
Список pgsql-general
Am 28.07.2016 um 15:25 schrieb Moreno Andreo:
> Hi folks! :-)
> I'm about to bring up my brand new production server and I was
> wondering if it's possible to calculate (approx.) the WAL directory size.
> I have to choose what's better in terms of cost vs. performance (we
> are on Google Cloud Platform) between a ramdisk or a separate
> persistent disk. Obviously ramdisk will be times faster disk, but
> having a, say, 512 GB ramdisk will be a little too expensive :-)
>

Don't use a RAM-Disk for WAL! DON'T! NEVER!

You really need only some GB, if you are using Replication. Without
Replication 1 GB would be fine, even with replication. But it must be
realible!

Andreas


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

Предыдущее
От: James Keener
Дата:
Сообщение: Re: Uber migrated from Postgres to MySQL
Следующее
От: Anton Ananich
Дата:
Сообщение: Re: GIN Indexes: Extensibility