Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org, Michael Clemmons <glassresistor(at)gmail(dot)com>, Hannu Krosing <hannu(at)2ndquadrant(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Subject: Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)
Date: 2010-01-20 05:21:07
Message-ID: 4B5692C3.6080807@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Greg Stark wrote:
> On Tue, Jan 19, 2010 at 2:52 PM, Greg Stark <gsstark(at)mit(dot)edu> wrote:
>
>> Barring any objections shall I commit it like this?
>>
>
> Actually before we get there could someone who demonstrated the
> speedup verify that this patch still gets that same speedup?
>

I think the final version of this patch could use at least one more
performance checking report that it does something useful. We got a lot
of data from Andres, but do we know that the improvements here hold for
others too? I can take a look at it later this week, I have some
interest in this area.

--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2010-01-20 05:26:26 Re: GUC failure on exception
Previous Message Andres Freund 2010-01-20 05:14:59 Re: An example of bugs for Hot Standby

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2010-01-20 13:38:50 Re: a heavy duty operation on an "unused" table kills my server
Previous Message Andres Freund 2010-01-20 04:13:03 Re: [HACKERS] Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb)