| 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: | 2007-09-01 00:23:39 |
| Message-ID: | 20070901002339.GQ8046@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Vinogradovs | 2007-09-01 00:31:08 | Re: WAL to RAW devices ? |
| Previous Message | Alex Vinogradovs | 2007-09-01 00:18:13 | Re: WAL to RAW devices ? |