Thread: 64 bit or 32 bit?
Hi,
I'll setup a PostgreSQL server and a web server on a 2 GB ram VPS service.
Since the RAM is below 4 GB, should I choose my linux and server apps 64 bit or 32 bit?
--As of June 5, 2014 6:55:55 PM +0300, Yuksel Pinarbasi is alleged to have said: > Hi, > I'll setup a PostgreSQL server and a web server on a 2 GB ram VPS > service. > Since the RAM is below 4 GB, should I choose my linux and server apps 64 > bit or 32 bit? --As for the rest, it is mine. At this point in time, I'd only use 32 bit if the hardware required it. Go 64 bit. Daniel T. Staal --------------------------------------------------------------- This email copyright the author. Unless otherwise noted, you are expressly allowed to retransmit, quote, or otherwise use the contents for non-commercial purposes. This copyright will expire 5 years after the author's death, or in 30 years, whichever is longer, unless such a period is in excess of local copyright law. ---------------------------------------------------------------
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
On Thu, Jun 5, 2014 at 5:57 PM, Daniel Staal <DStaal@usa.net> wrote:
--As for the rest, it is mine.--As of June 5, 2014 6:55:55 PM +0300, Yuksel Pinarbasi is alleged to have said:Hi,
I'll setup a PostgreSQL server and a web server on a 2 GB ram VPS
service.
Since the RAM is below 4 GB, should I choose my linux and server apps 64
bit or 32 bit?
At this point in time, I'd only use 32 bit if the hardware required it. Go 64 bit.
Daniel T. Staal
---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
Got it.
Thanks.
----- Original Message -----To: PGSQL-NoviceSent: Friday, June 06, 2014 3:42 PMSubject: 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