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