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

Re: Block at a time ...

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Scott Carey <scott(at)richrelevance(dot)com>
Cc: Craig James <craig_james(at)emolecules(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Block at a time ...
Date: 2010-03-22 21:25:07
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
On Mon, Mar 22, 2010 at 6:47 PM, Scott Carey <scott(at)richrelevance(dot)com> wrote:
> Its fairly easy to break.  Just do a parallel import with say, 16 concurrent tables being written to at once.  Result?  Fragmented tables.

Fwiw I did do some investigation about this at one point and could not
demonstrate any significant fragmentation. But that was on Linux --
different filesystem implementations would have different success
rates. And there could be other factors as well such as how full the
fileystem is or how old it is.


In response to

pgsql-performance by date

Next:From: Carlo StonebanksDate: 2010-03-22 22:19:11
Subject: Re: default_statistics_target
Previous:From: Dave CrookeDate: 2010-03-22 21:06:00
Subject: Re: Block at a time ...

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