Re: 64-bit XIDs again

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: 64-bit XIDs again
Дата
Msg-id 55BA3EE7.1050500@commandprompt.com
обсуждение исходный текст
Ответ на Re: 64-bit XIDs again  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On 07/30/2015 08:04 AM, Simon Riggs wrote:

>     There is a big downside to expanding xmin/xmax to 64 bits: it takes
>     space. More space means more memory needed for caching, more memory
>     bandwidth, more I/O, etc.
>
>
> My feeling is that the overhead will recede in time. Having a nice,
> simple change to remove old bugs and new would help us be more robust.
>
> But let's measure the overhead before we try to optimize it away.

In field experience would agree with you. The amount of memory people 
are arbitrarily throwing at databases now is pretty significant. It is 
common to have >64GB of memory. Heck, I run into >128GB all the time and 
seeing >192GB is no longer a, "Wow".

JD



-- 
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: 64-bit XIDs again
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: security labels on databases are bad for dump & restore