Thread: How to determine max int
Good evening,
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.
Thanks again,
Melvin
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.
Thanks again,
Melvin
On 11/11/2013 4:14 PM, Melvin Call wrote: > 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. x86_64 integers are 32bit, bigints are 64bit. this is true in most all programming environments, from C on. -- john r pierce 37N 122W somewhere on the middle of the left coast
On 11/11/2013 7:14 PM, Melvin Call wrote: > Good evening, > > 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. The documentation seems pretty clear on integer data types: http://www.enterprisedb.com/docs/en/9.2/pg/datatype-numeric.html#DATATYPE-INT From the documentation, the range of integer data types is not platform-specific, other than for warning about BIGINT. Perhaps you are remembering compiler documentation, where the default integer size typically *is* platform-dependent? -- Guy Rouillier
On Mon, Nov 11, 2013 at 6:29 PM, John R Pierce <pierce@hogranch.com> 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
On Mon, Nov 11, 2013 at 6:35 PM, Guy Rouillier <guy.rouillier@gmail.com> wrote:
On 11/11/2013 7:14 PM, Melvin Call wrote:The documentation seems pretty clear on integer data types:Good evening,
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.
http://www.enterprisedb.com/docs/en/9.2/pg/datatype-numeric.html#DATATYPE-INT
From the documentation, the range of integer data types is not platform-specific, other than for warning about BIGINT. Perhaps you are remembering compiler documentation, where the default integer size typically *is* platform-dependent?
--
Guy Rouillier
Thanks Guy. Some dumb notion that I came up with somewhere in the past. I appreciate y'all setting me straight.
Melvin