Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-performance by date

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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group