Re: Is there a cache consistent interface to tables ?

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Is there a cache consistent interface to tables ?
Дата
Msg-id CAMsr+YEwf2RYK4Dd7LuiW6YHTfcpPcdE9eJ2Qw7k3PD6_JzCrQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Is there a cache consistent interface to tables ?  (Gary M <garym@oedata.com>)
Список pgsql-hackers
Дерево обсуждения
On 11 February 2018 at 04:44, Gary M <garym@oedata.com> wrote:
Thanks Craig,

As I'm back in pg code after many years, I'm feeling much better there's one (1) or two (2) items causing the hiccup.  Rereading your comments, I'm agreeing with you. I'm considering bumping up the ram to 512gb as a RAM disk just for consistent profiling (an old bad habit). 

I'm reassessing my profiling plan.  I'm getting ahead of myself thinking the OS is not having a significant effect. 

Definitely. Especially since PostgreSQL uses buffered I/O.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: postgres_fdw: perform UPDATE/DELETE .. RETURNING on a join directly
Следующее
От: Nikolay Shaplov
Дата:
Сообщение: Re: [PATCH][PROPOSAL] Add enum releation option type