| From: | "Yuksel Pinarbasi" <yukselp(at)gmail(dot)com> |
|---|---|
| To: | "PGSQL-Novice" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: 64 bit or 32 bit? |
| Date: | 2014-06-06 13:07:22 |
| Message-ID: | 1B2A489421F84A74A4A4EE16F5479833@yukiPC |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Got it.
Thanks.
----- Original Message -----
From: hubert depesz lubaczewski
To: PGSQL-Novice
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jake fagan | 2014-06-06 16:38:45 | WHERE condition lost from conditional unique index |
| Previous Message | hubert depesz lubaczewski | 2014-06-06 12:42:46 | Re: 64 bit or 32 bit? |