pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Greg Stark <gsstark@mit.edu>
To: Scott Carey <scott@richrelevance.com>
Cc: Craig James <craig_james@emolecules.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Block at a time ...
Date: Mon, 22 Mar 2010 21:25:07 +0000
Message-ID: <407d949e1003221425i5ed0dd75x9203780cff236701@mail.gmail.com> (raw)
In-Reply-To: <D254FE0F-9B3A-432D-AA38-C8B526A7ECEB@richrelevance.com>
References: <ca24673e1003161658g6a0fa30dg2c158db395ac08@mail.gmail.com>
	<20100317001405.GL3037@alvh.no-ip.org>
	<op.u9pa7vzleorkce@localhost>
	<407d949e1003170252y72d223c3kcc18266140a60997@mail.gmail.com>
	<4BA10648.6010609@emolecules.com>
	<D254FE0F-9B3A-432D-AA38-C8B526A7ECEB@richrelevance.com>

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

view thread (14+ messages)  latest in thread

Message-ID: <407d949e1003221425i5ed0dd75x9203780cff236701@mail.gmail.com>
Permalink:  ../407d949e1003221425i5ed0dd75x9203780cff236701@mail.gmail.com/
Also on:    postgresql.org/message-id/407d949e1003221425i5ed0dd75x9203780cff236701@mail.gmail.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: gsstark@mit.edu, scott@richrelevance.com, craig_james@emolecules.com
  Subject: Re: Block at a time ...
  In-Reply-To: <407d949e1003221425i5ed0dd75x9203780cff236701@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox