Re: 64-bit XIDs again

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.