Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 4E9DB9FB961 for ; Thu, 31 May 2007 10:21:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 02130-02 for ; Thu, 31 May 2007 10:21:40 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx1.wp.pl (mx1.wp.pl [212.77.101.5]) by postgresql.org (Postfix) with ESMTP id 55DAB9FB91F for ; Thu, 31 May 2007 10:21:45 -0300 (ADT) Received: (wp-smtpd smtp.wp.pl 18850 invoked from network); 31 May 2007 15:21:42 +0200 Received: from ip-213-17-164-70.netia.com.pl (HELO [127.0.0.1]) (ipluta@[213.17.164.70]) (envelope-sender ) by smtp.wp.pl (WP-SMTPD) with SMTP for ; 31 May 2007 15:21:42 +0200 Message-ID: <465ECBE4.9020600@wp.pl> Date: Thu, 31 May 2007 15:21:40 +0200 From: Ireneusz Pluta User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: DB cluster sharing between 32 and 64 bit software versions Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-WP-AV: skaner antywirusowy poczty Wirtualnej Polski S. A. X-WP-SPAM: NO 0000000 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/636 X-Sequence-Number: 25026 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?