Postgres Pro
Downloads
Home   >   mailing lists

Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)
Date
Msg-id 407d949e0912290248y24acd059q1f31d6f0d057bbe6@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)  (Andres Freund <andres@anarazel.de>)
Responses Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
On Tue, Dec 29, 2009 at 2:05 AM, Andres Freund <andres@anarazel.de> wrote:
>  Reads Completed:        2,        8KiB  Writes Completed:     2362,    29672KiB
> New:
>  Reads Completed:        0,        0KiB  Writes Completed:      550,     5960KiB

It looks like the new method is only doing 1/6th as much i/o. Do you
know what's going on there?


--
greg

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: New VACUUM FULL still needed?
Next
From: "Tarun Sharma"
Date:
Subject: Can we hide data from the superadmin