Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 79D7D2E0033 for ; Mon, 26 Nov 2007 14:53:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 43034-04 for ; Mon, 26 Nov 2007 14:52:40 -0400 (AST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.180]) by postgresql.org (Postfix) with ESMTP id EEA8A2E01AC for ; Mon, 26 Nov 2007 14:52:53 -0400 (AST) Received: by py-out-1112.google.com with SMTP id u77so1790331pyb for ; Mon, 26 Nov 2007 10:52:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=rW92WBGNrZKxXn02Fk2L/K+HZ3zCCc0k16OFjjEmLNg=; b=m05SlN4GQmeTT3v9hjWHdA21qz0PStMBUDg0NsGqYS4xh4BHsnZNwBgJJ9YLne5vqOP3+3ISWjrOC9CnjyWPTNtMIw26ZxMA/E7pSrOmUA/KI2Fe5fRLeuIULYmjuui8aP0s1YB0kvL0faLQmPQS54ioN4lvsROJ71stIb1nt1A= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=pR/+mbZ6xnIn0e23Pb+TXtLj+EgWaUo/37IwXgB7SoU37BF2lAYEx6l70C2GXM2N/vXOijPRWguRBBMsp6fMBe2V0LPjD3rtr9vvZKgDs52EbVzUPt/WvjfqTOhmL71/6KrTkr5kr1cANTL0ycOJi+C5rTMfeG8iE03SIlNK5JE= Received: by 10.65.189.20 with SMTP id r20mr6626015qbp.1196103172633; Mon, 26 Nov 2007 10:52:52 -0800 (PST) Received: by 10.64.242.15 with HTTP; Mon, 26 Nov 2007 10:52:52 -0800 (PST) Message-ID: <8078a1730711261052i1e904ce7rdb545aade244b666@mail.gmail.com> Date: Mon, 26 Nov 2007 10:52:52 -0800 From: "Medi Montaseri" To: "Chris Browne" Subject: Re: Migrating from 32 to 64 bit Cc: pgsql-admin@postgresql.org In-Reply-To: <60r6iddmhj.fsf@dba2.int.libertyrms.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1416_21668766.1196103172634" References: <4748B148.6050001@lncsa.com> <474971C0.3090503@theendofthetunnel.de> <8078a1730711252124uc5e0cbdpdc7807d92480645b@mail.gmail.com> <60r6iddmhj.fsf@dba2.int.libertyrms.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/221 X-Sequence-Number: 27464 ------=_Part_1416_21668766.1196103172634 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I agree with you practical points....I qualified my comments by saying....theoretically speaking.... Cheers Medi On Nov 26, 2007 8:01 AM, Chris Browne wrote: > montaseri@gmail.com ("Medi Montaseri") writes: > > But theoretically speaking, 32 or 64-bit ness of the application (ie the > postmaster server) should not influence the data types offered by a > particular DB > > version. That is the semantics of data types and cpu-arch (register > width, big endian, little endian, sparc, mips, x86), etc ) offered by a > particular DB > > version should be orthogonal. > > A practical example is when I first begin my business on a Mac, then I > move the database to a Sun and then on to a mainframe.... > > That's well and fine, but the point is that when those (reasonably > generic!) data types get compiled into code for a particular platform, > with particular endianness and word size, how it is optimal to > represent them will vary based on the characteristics of the platform. > > As a result, not only do you need different executable binaries each > platform, but you also need different binary database structures on > each platform. > > A conceptually mitigating factor should be that by the time you get > around to changing platforms, there will likely be a Newer, Better, > Major PostgreSQL version available. So you should be considering > doing a migration from "old, slower, inferior version on the inferior > platform" to the "better, stronger, faster version on the superior > platform." With THAT context, the need to run initdb is further > "given." > -- > output = ("cbbrowne" "@" "linuxdatabases.info") > http://www3.sympatico.ca/cbbrowne/x.html > "Have you noticed that, when we were young, we were told that > `everybody else is doing it' was a really stupid reason to do > something, but now it's the standard reason for picking a particular > software package?" -- Barry Gehm > > ---------------------------(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 > ------=_Part_1416_21668766.1196103172634 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I agree with you practical points....I qualified my comments by saying....theoretically speaking....

Cheers
Medi

On Nov 26, 2007 8:01 AM, Chris Browne < cbbrowne@acm.org> wrote:
montaseri@gmail.com ("Medi Montaseri") writes:
> But theoretically speaking, 32 or 64-bit ness of the application (ie the postmaster server) should not influence the data types offered by a particular DB
> version. That is the semantics of data types and cpu-arch (register width, big endian, little endian, sparc, mips, x86), etc ) offered by a particular DB
> version should be orthogonal.
> A practical example is when I first begin my business on a Mac, then I move the database to a Sun and then on to a mainframe....

That's well and fine, but the point is that when those (reasonably
generic!) data types get compiled into code for a particular platform,
with particular endianness and word size, how it is optimal to
represent them will vary based on the characteristics of the platform.

As a result, not only do you need different executable binaries each
platform, but you also need different binary database structures on
each platform.

A conceptually mitigating factor should be that by the time you get
around to changing platforms, there will likely be a Newer, Better,
Major PostgreSQL version available.  So you should be considering
doing a migration from "old, slower, inferior version on the inferior
platform" to the "better, stronger, faster version on the superior
platform."  With THAT context, the need to run initdb is further
"given."
--
output = ("cbbrowne" "@" " linuxdatabases.info")
http://www3.sympatico.ca/cbbrowne/x.html
"Have  you noticed   that,  when we were   young,  we were   told that
`everybody else   is doing  it' was   a  really  stupid reason  to  do
something,  but now it's the standard  reason for picking a particular
software package?" -- Barry Gehm

---------------------------(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

------=_Part_1416_21668766.1196103172634--