| From: | Florian Weimer <fw(at)deneb(dot)enyo(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, Greg Stark <gsstark(at)mit(dot)edu>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Re: Faster CREATE DATABASE by delaying fsync |
| Date: | 2010-02-14 20:24:24 |
| Message-ID: | 87wryfpnuv.fsf@mid.deneb.enyo.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
* Tom Lane:
>> Which options would that be? I am not aware that there any for any of the
>> recent linux filesystems.
>
> Shouldn't journaling of metadata be sufficient?
You also need to enforce ordering between the directory update and the
file update. The file metadata is flushed with fsync(), but the
directory isn't. On some systems, all directory operations are
synchronous, but not on Linux.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Mielke | 2010-02-14 20:41:02 | Re: Re: Faster CREATE DATABASE by delaying fsync |
| Previous Message | Tom Lane | 2010-02-14 20:15:30 | LISTEN/NOTIFY versus encoding conversion |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Mielke | 2010-02-14 20:41:02 | Re: Re: Faster CREATE DATABASE by delaying fsync |
| Previous Message | Boszormenyi Zoltan | 2010-02-14 19:05:30 | Re: PostgreSQL on SMP Architectures |