From: | Martin Marques <martin(at)marquesminen(dot)com(dot)ar> |
---|---|
To: | Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl> |
Cc: | rihad(at)mail(dot)ru, pgsql-general(at)postgresql(dot)org |
Subject: | Re: full_page_writes = off? |
Date: | 2007-12-01 12:04:44 |
Message-ID: | 47514DDC.70607@marquesminen.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-general |
Tomasz Ostrowski escribió:
> On Sat, 01 Dec 2007, rihad wrote:
>
>> fsync = on;
>> synchronous_commit = off;
>> full_page_writes = off;
>> Thanks for any insights or clarifying missed points.
>
> Also check whether a disks have write-caching turned off - it should.
> On Linux the command is:
> # hdparm -W /dev/sda
> /dev/sda:
> write-caching = 0 (off)
Uh? That command as was written lacks an argument for -W (0/1). From the
hdparm --help:
-W set drive write-caching flag (0/1) (DANGEROUS)
# hdparm -V
hdparm v6.9
From | Date | Subject | |
---|---|---|---|
Next Message | Tomasz Ostrowski | 2007-12-01 12:16:01 | Re: full_page_writes = off? |
Previous Message | Tomasz Ostrowski | 2007-12-01 11:47:57 | Re: full_page_writes = off? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tomasz Ostrowski | 2007-12-01 12:16:01 | Re: full_page_writes = off? |
Previous Message | Tomasz Ostrowski | 2007-12-01 11:47:57 | Re: full_page_writes = off? |