Re: Install on 32 or 64 bit Linux?

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Install on 32 or 64 bit Linux?
Date: 2007-08-28 23:01:59
Message-ID: 46D4A967.3030405@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 08/28/07 16:21, Ralph Smith wrote:
> Hello,
>
> We're at a crossroads here and it's time to upgrade boxes and versions
> of PG.
> This eMail query is about the first step.
>
> Are there any recommendations on whether to install onto 32 vs 64 bit
> Linux?
> We're going to be using virtual machines.

Which hypervisor?

> Our application consists mostly of near-sequential inserts into a LARGE
> table, accompanied by updates into much smaller tables.
> I perform the occasional queries on the large table, requiring
> sequential scans.
>
> Are there any indications whether 32 or 64 bit Linux would be preferable?

You haven't told us the important stuff yet. Primarily:

How *big* is the database?

How many inserts/minute?

What else will this box be doing besides inserting records?

How fast are the disks?

SCSI or SATA/IDE?

How much RAM?

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFG1KlnS9HxQb37XmcRAkSJAKDIHfK7YzumbMrZ6iPKMUyDnTnafQCbBKDJ
XplucXPbBqXtruC4rlHc+yM=
=Shq4
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2007-08-28 23:08:37 Re: Is there a better way to do this?
Previous Message Michael Glaesemann 2007-08-28 22:46:25 Re: Is there a better way to do this?