Re: 64-bit XIDs again - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: 64-bit XIDs again
Date
Msg-id 55BA3EE7.1050500@commandprompt.com
Whole thread Raw
In response to Re: 64-bit XIDs again  (Simon Riggs <simon@2ndQuadrant.com>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: 64-bit XIDs again
Next
From: Alvaro Herrera
Date:
Subject: Re: security labels on databases are bad for dump & restore