Re: Block at a time ... - Mailing list pgsql-performance

From Greg Stark
Subject Re: Block at a time ...
Date
Msg-id 407d949e1003221425i5ed0dd75x9203780cff236701@mail.gmail.com
Whole thread Raw
In response to Re: Block at a time ...  (Scott Carey <scott@richrelevance.com>)
List pgsql-performance
On Mon, Mar 22, 2010 at 6:47 PM, Scott Carey <scott@richrelevance.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.

--
greg

pgsql-performance by date:

Previous
From: Dave Crooke
Date:
Subject: Re: Block at a time ...
Next
From: "Carlo Stonebanks"
Date:
Subject: Re: default_statistics_target