Re: requested shared memory size overflows size_t - Mailing list pgsql-performance

From Scott Carey
Subject Re: requested shared memory size overflows size_t
Date
Msg-id 08A32E7F-5FFC-4341-A543-E0BFB6420B7E@richrelevance.com
Whole thread Raw
In response to Re: requested shared memory size overflows size_t  (Greg Smith <greg@2ndquadrant.com>)
Responses Re: requested shared memory size overflows size_t  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Jun 14, 2010, at 7:06 PM, Greg Smith wrote:

> I really cannot imagine taking a system as powerful as you're using here
> and crippling it by running through a VM.  You should be running Ubuntu
> directly on the hardware, ext3 filesystem without LVM, split off RAID-1
> drive pairs dedicated to OS and WAL, then use the rest of them for the
> database.
>

Great points.  There is one other option that is decent for the WAL:
If splitting out a volume is not acceptable for the OS and WAL -- absolutely split those two out into their own
partitions. It is most important to make sure that WAL and data are not on the same filesystem, especially if ext3 is
involved.


> --
> Greg Smith  2ndQuadrant US  Baltimore, MD
> PostgreSQL Training, Services and Support
> greg@2ndQuadrant.com   www.2ndQuadrant.us
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance


pgsql-performance by date:

Previous
From: Scott Carey
Date:
Subject: Re: requested shared memory size overflows size_t
Next
From: Tom Lane
Date:
Subject: Re: requested shared memory size overflows size_t