On Mon, Nov 11, 2013 at 6:29 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 11/11/2013 4:14 PM, Melvin Call wrote:x86_64 integers are 32bit, bigints are 64bit. this is true in most all programming environments, from C on.
I could swear I read somewhere that the default integer size on 64-bit systems running 9.1 is eight bytes, or the equivalent of a bigint. But reading through the user guide it seems that it is indeed still just four-bytes. Can anyone verify that for me, or point me to a way to verify it? I see nothing in pg_settings which is where I thought to look. Not a big deal, I just need to know for the data dictionary.
That is what I thought. I have no idea where I came up with the notion that it was 64 bits, but I have it in a note I took a while back. I guess I really am going crazy!
Thanks John
