Re: Slowdown problem when writing 1.7million records

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: Slowdown problem when writing 1.7million records
Дата
Msg-id Pine.BSF.4.32.0102282000210.97443-100000@zoraida.reyes.somos.net
обсуждение исходный текст
Ответ на Re: Slowdown problem when writing 1.7million records  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
On Wed, 28 Feb 2001, Bruce Momjian wrote:

>> * Be smarter about insertion of already-ordered data into btree index
>
> Added.  I thought our btree code was self-balancing.

My understanding of most "self-balancing" algorithms is that the would
have a significantly greater overhead in adding sequential
data to any self balancing algorithm. Likely greater than even doing some
randomization of the data.


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

Предыдущее
От: Jean-Christophe Boggio
Дата:
Сообщение: Performance tuning
Следующее
От: Tom Lane
Дата:
Сообщение: Re: how to vacuum from cron?