| From: | Scott Carey <scott(at)richrelevance(dot)com> |
|---|---|
| To: | Greg Smith <greg(at)2ndquadrant(dot)com> |
| Cc: | Tom Wilcox <hungrytom(at)gmail(dot)com>, Bob Lunney <bob_lunney(at)yahoo(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: requested shared memory size overflows size_t |
| Date: | 2010-06-15 03:49:40 |
| Message-ID: | 08A32E7F-5FFC-4341-A543-E0BFB6420B7E@richrelevance.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)2ndQuadrant(dot)com www.2ndQuadrant.us
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-06-15 03:57:11 | Re: requested shared memory size overflows size_t |
| Previous Message | Scott Carey | 2010-06-15 03:27:11 | Re: requested shared memory size overflows size_t |