Re: Slowdown problem when writing 1.7million records - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Slowdown problem when writing 1.7million records
Date
Msg-id Pine.BSF.4.32.0102282000210.97443-100000@zoraida.reyes.somos.net
Whole thread Raw
In response to Re: Slowdown problem when writing 1.7million records  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Jean-Christophe Boggio
Date:
Subject: Performance tuning
Next
From: Tom Lane
Date:
Subject: Re: how to vacuum from cron?