DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:sender:in-reply-to:references:from:date
	:x-google-sender-auth:message-id:subject:to:cc:content-type
	:content-transfer-encoding;
	b=n+4FAVMSaFJKaBr/dD3PaZVsGy8WyRxVtwV1rw8Fwnf6RuHAuX7w5XrthwN/FBzF8p
	9B+iR0sSE+z6bPXFDakc0q8RcnJ/dbBFrCnNzH3MJxm3qemLX1K7kxst5aj36kjCTTq7
	ESkLNorW5eZj+wKgZ1H6SwHz0cW7hzQfpmY8c=
MIME-Version: 1.0
In-Reply-To: <407d949e1002140603v1c7515d7t697568a3865ac6fe@mail.gmail.com>
References: <4427a97a0912101235x3ade510blcc00d5ce9883c6b6@mail.gmail.com>
	<20100208030901.GA7407@alvh.no-ip.org>
	<603c8f071002072053w16897addtd52fcc4cf880df53@mail.gmail.com>
	<201002110327.35810.andres@anarazel.de>
	<603c8f071002120749o6a2e9e54h5cf21dc91d1790b9@mail.gmail.com>
	<407d949e1002140603v1c7515d7t697568a3865ac6fe@mail.gmail.com>
From: Greg Stark <gsstark@mit.edu>
Date: Sun, 14 Feb 2010 15:31:58 +0000
Message-ID: <407d949e1002140731j85a4f97nc053ec1b0f3cc458@mail.gmail.com>
Subject: Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1
	ubuntu karmic slow createdb)
To: Robert Haas <robertmhaas@gmail.com>
Cc: Andres Freund <andres@anarazel.de>, pgsql-hackers@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Sun, Feb 14, 2010 at 2:03 PM, Greg Stark <gsstark@mit.edu> wrote:
> On Fri, Feb 12, 2010 at 3:49 PM, Robert Haas <robertmhaas@gmail.com> wrot=
e:
>> Greg Stark, have you managed to get your access issues sorted out? =A0If
>
> Yep, will look at this today.

So I think we have a bigger problem than just copydir.c. It seems to
me we should be fsyncing the table space data directories on every
checkpoint. Otherwise any newly created relations or removed relations
could disappear even though the data in them was fsynced. I'm thinking
I should add an _mdfd_opentblspc(reln) call which returns a file
descriptor for the tablespace and have mdsync() use that to sync the
directory whenever it fsyncs a relation. It would be nice to remember
which tablespaces have been fsynced and only fsync them once though,
that would need another hash table just for tablespaces.

We probably also need to fsync the pg_xlog directory every time we
create or rename an xlog segment.

Are there any other places we do directory operations which we need to
be permanent?


--=20
greg