Gregory Stark wrote:
"Gregory Stark" <[EMAIL PROTECTED]> writes:
"Tom Lane" <[EMAIL PROTECTED]> writes:
Josh Berkus <[EMAIL PROTECTED]> writes:
I've just noticed that pg_controldata doesn't say anything about whether
the database is 64-bit or 32-bit.
That's because there is no such concept.
I think the relevant concept is whether Datum is 32-bit or 64-bit wide.
Oh, I see what you meant now. Datum is a purely in-memory concept, it doesn't
actually reach disk.
We could always tighten this up a bit by listing the alignment of a handful of
built-in data types but I suppose there will always be holes in this area
anyways.
What are we gaining here? A 32bit postmaster can't start a 64bit one...
Running select version() will tell you if you are running 64 or 32bit...
What am I missing?
Joshua D. Drake
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match