Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: WAL to RAW devices ?
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Alex Vinogradovs <AVinogradovs(at)Clearpathnet(dot)com>
- Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
- Subject: Re: WAL to RAW devices ?
- Date: Fri, 31 Aug 2007 20:23:39 -0400
- Message-id: <20070901002339.GQ8046@alvh.no-ip.org> <text/plain>
Alex Vinogradovs wrote:
> WAL segments already have their structure. Filesystem would be an
> overhead,
In this case you can choose a filesystem with lower overhead. For
example with WAL you don't need a journalling filesystem at all, so
using ext2 is not a bad idea. For Pg data files, you need journalling
of metadata only, not of data; the latter is provided by WAL. So you
can mount the data filesystem with the option data=writeback.
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"All rings of power are equal,
But some rings of power are more equal than others."
(George Orwell's The Lord of the Rings)
- Follow-Ups:
- Re: WAL to RAW devices ?
- From: Alex Vinogradovs
- Re: WAL to RAW devices ?
- References:
- URGENT: Whole DB down ("no space left on device")
- From: Phoenix Kiula
- Re: URGENT: Whole DB down ("no space left on device")
- From: Zoltan Boszormenyi
- Re: URGENT: Whole DB down ("no space left on device")
- From: Josh Tolley
- Re: URGENT: Whole DB down ("no space left on device")
- From: Phoenix Kiula
- Re: URGENT: Whole DB down ("no space left on device")
- From: Jeff Davis
- WAL to RAW devices ?
- From: Alex Vinogradovs
- Re: WAL to RAW devices ?
- From: Tom Lane
- Re: WAL to RAW devices ?
- From: Alex Vinogradovs
- URGENT: Whole DB down ("no space left on device")
- Prev by Date: Re: WAL to RAW devices ?
- Next by Date: Re: WAL to RAW devices ?
- Previous by thread: Re: WAL to RAW devices ?
- Next by thread: Re: WAL to RAW devices ?
- Indexes: