Re: Block at a time ...

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Block at a time ...
Дата
Msg-id 407d949e1003221425i5ed0dd75x9203780cff236701@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Block at a time ...  (Scott Carey <scott@richrelevance.com>)
Список 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 по дате отправления:

Предыдущее
От: Dave Crooke
Дата:
Сообщение: Re: Block at a time ...
Следующее
От: "Carlo Stonebanks"
Дата:
Сообщение: Re: default_statistics_target