Re: performance of temporary vs. regular tables

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: performance of temporary vs. regular tables
Дата
Msg-id AANLkTilN0Qrf0NoHRhGW4VWuRyj1Gpfe5qpLzeNHNyBH@mail.gmail.com
обсуждение исходный текст
Ответ на Re: performance of temporary vs. regular tables  (Joachim Worringen <joachim.worringen@iathh.de>)
Ответы Re: performance of temporary vs. regular tables  (Joachim Worringen <joachim.worringen@iathh.de>)
Список pgsql-performance
WAL does the same thing to DB journaling does to the FS.
Plus allows you to roll back (PITR).

As for the RAM, it will be in ram as long as OS decides to keep it in
RAM cache, and/or its in the shared buffers memory.
Unless you have a lot of doubt about the two, I don't think it makes
too much sens to setup ramdisk table space yourself. But try it, and
see yourself.
Make sure that you have logic in place, that would set it up, before
postgresql starts up, in case you'll reboot, or something.

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

Предыдущее
От: Joachim Worringen
Дата:
Сообщение: Re: performance of temporary vs. regular tables
Следующее
От: Konrad Garus
Дата:
Сообщение: Re: shared_buffers advice