From: Alvaro Herrera <alvherre@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Scott Carey <scott@richrelevance.com>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: Tom Wilcox <hungrytom@gmail.com>
Cc: Bob Lunney <bob_lunney@yahoo.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: requested shared memory size overflows size_t
Date: Wed, 16 Jun 2010 16:53:52 -0400
Message-ID: <1276721410-sup-6820@alvh.no-ip.org> (raw)
In-Reply-To: <26740.1276574231@sss.pgh.pa.us>
References: <584872.74177.qm@web39702.mail.mud.yahoo.com>
<4C167A8D.1060002@gmail.com>
<4C16E039.10803@2ndquadrant.com>
<08A32E7F-5FFC-4341-A543-E0BFB6420B7E@richrelevance.com>
<26740.1276574231@sss.pgh.pa.us>
Excerpts from Tom Lane's message of lun jun 14 23:57:11 -0400 2010:
> Scott Carey <scott@richrelevance.com> writes:
> > 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.
>
> Uh, no, WAL really needs to be on its own *spindle*. The whole point
> here is to have one disk head sitting on the WAL and not doing anything
> else except writing to that file.
However, there's another point here -- probably what Scott is on about:
on Linux (at least ext3), an fsync of any file does not limit to
flushing that file's blocks -- it flushes *ALL* blocks on *ALL* files in
the filesystem. This is particularly problematic if you have pgsql_tmp
in the same filesystem and do lots of disk-based sorts.
So if you have it in the same spindle but on a different filesystem, at
least you'll avoid that extra fsync work, even if you have to live with
the extra seeking.
--
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, tgl@sss.pgh.pa.us, scott@richrelevance.com, greg@2ndquadrant.com, hungrytom@gmail.com, bob_lunney@yahoo.com
Subject: Re: requested shared memory size overflows size_t
In-Reply-To: <1276721410-sup-6820@alvh.no-ip.org>
References: <584872.74177.qm@web39702.mail.mud.yahoo.com> <4C167A8D.1060002@gmail.com> <4C16E039.10803@2ndquadrant.com> <08A32E7F-5FFC-4341-A543-E0BFB6420B7E@richrelevance.com> <26740.1276574231@sss.pgh.pa.us> <1276721410-sup-6820@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox