| 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: | Whole Thread | Raw Message | 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? |