Re: 64 bit or 32 bit? - Mailing list pgsql-novice

From Yuksel Pinarbasi
Subject Re: 64 bit or 32 bit?
Date
Msg-id 1B2A489421F84A74A4A4EE16F5479833@yukiPC
Whole thread Raw
In response to Re: 64 bit or 32 bit?  (hubert depesz lubaczewski <depesz@gmail.com>)
List pgsql-novice

Got it.
Thanks.
 
 
----- Original Message -----
Sent: Friday, June 06, 2014 3:42 PM
Subject: Re: [NOVICE] 64 bit or 32 bit?

Using 64 bit will make it easier if you'd ever want to migrate out to beefier hardware.

When architecture is different (for example 32bit vs. 64bit) you have to use pg_dump to migrate (or slony, or some other trigger-based replication).

When architecture is the same, you can migrate by stopping Pg, sending PGDATA directory to new machine, and then starting Pg there. Or using PostgreSQL streaming replication and failing over. Faster, cheaper, better.

If you know that you'll never move out of this VPS - you could consider 32 bit, but that's rather unlikely to assume.

depesz

pgsql-novice by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: 64 bit or 32 bit?
Next
From: jake fagan
Date:
Subject: WHERE condition lost from conditional unique index