pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedDB cluster sharing between 32 and 64 bit software versions
2+ messages / 2 participants
[nested] [flat]
* DB cluster sharing between 32 and 64 bit software versions
@ 2007-05-31 13:21 Ireneusz Pluta <ipluta@wp.pl>
2007-05-31 13:36 ` Re: DB cluster sharing between 32 and 64 bit software versions Bill Moran <wmoran@collaborativefusion.com>
0 siblings, 1 reply; 2+ messages in thread
From: Ireneusz Pluta @ 2007-05-31 13:21 UTC (permalink / raw)
To: pgsql-performance
Hello,
I am going to build a new PostgreSQL dedicated server, on FreeBSD. Before it goes to production
service I need to make some tests and take configuration decisions, focused on my application needs.
Usual thing. One of them is selection of one of 32 or 64 bit versions of both OS and PG. What I am
going to do is to install both versions on different filesystems of the same machine. As a
consequence I would also have to deal with two independent copies of my real databases on which I
want to perfrom my tests. However, the databases are rather large, so I am thinking about
possibilities of not to have to restore two copies of my data, but use just one instead, and sharing
it between the 32 and 64 versions, across reboots.
Would that scenario work, or I am simply too naive considering it?
Thanks
Ireneusz Pluta
PS.
Or rather, instead of testing 32/64 bit, I would just simply go with 64 bit, considering that the
server has quad core X5355 Xeon and 16GB RAM?
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: DB cluster sharing between 32 and 64 bit software versions
2007-05-31 13:21 DB cluster sharing between 32 and 64 bit software versions Ireneusz Pluta <ipluta@wp.pl>
@ 2007-05-31 13:36 ` Bill Moran <wmoran@collaborativefusion.com>
0 siblings, 0 replies; 2+ messages in thread
From: Bill Moran @ 2007-05-31 13:36 UTC (permalink / raw)
To: Ireneusz Pluta <ipluta@wp.pl>; +Cc: pgsql-performance
In response to Ireneusz Pluta <ipluta@wp.pl>:
> Hello,
>
> I am going to build a new PostgreSQL dedicated server, on FreeBSD. Before it goes to production
> service I need to make some tests and take configuration decisions, focused on my application needs.
> Usual thing. One of them is selection of one of 32 or 64 bit versions of both OS and PG. What I am
> going to do is to install both versions on different filesystems of the same machine. As a
> consequence I would also have to deal with two independent copies of my real databases on which I
> want to perfrom my tests. However, the databases are rather large, so I am thinking about
> possibilities of not to have to restore two copies of my data, but use just one instead, and sharing
> it between the 32 and 64 versions, across reboots.
>
> Would that scenario work, or I am simply too naive considering it?
It won't work, unfortunately. The on-disk representation of the data is
different between ia32 and amd64.
--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/
wmoran@collaborativefusion.com
Phone: 412-422-3463x4023
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-05-31 13:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-31 13:21 DB cluster sharing between 32 and 64 bit software versions Ireneusz Pluta <ipluta@wp.pl>
2007-05-31 13:36 ` Bill Moran <wmoran@collaborativefusion.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox