Re: Install on 32 or 64 bit Linux? - Mailing list pgsql-general

From Ron Johnson
Subject Re: Install on 32 or 64 bit Linux?
Date
Msg-id 46D4A967.3030405@cox.net
Whole thread Raw
In response to Install on 32 or 64 bit Linux?  (Ralph Smith <smithrn@u.washington.edu>)
List 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-----

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Is there a better way to do this?
Next
From: Michael Glaesemann
Date:
Subject: Re: Is there a better way to do this?