Re: COPY Fillfactor patch

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: COPY Fillfactor patch
Дата
Msg-id 15251.1113314185@sss.pgh.pa.us
обсуждение исходный текст
Ответ на COPY Fillfactor patch  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: COPY Fillfactor patch  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-patches
Simon Riggs <simon@2ndquadrant.com> writes:
> During recent tuning of the TPC-C workload, I produced the following
> patch to force COPY to leave some space in each data block when it loads
> data into heap relations.

This is an amazingly ugly way to do it.  Put the info into the Relation
structure instead of cluttering heap_insert's API.  (This would mean
that *every* heap_insert is affected, not only COPY, which is what you
want anyway I would think.)

In practice, a real fix for this would add a column to pg_class, in
which case you could get it from the Relation for free.

            regards, tom lane

В списке pgsql-patches по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: OS Locale UTF-8
Следующее
От: Neil Conway
Дата:
Сообщение: Re: COPY Fillfactor patch