Re: Slowdown problem when writing 1.7million records

From: Francisco Reyes <fran(at)reyes(dot)somos(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Slowdown problem when writing 1.7million records
Date: 2001-03-01 01:05:50
Message-ID: Pine.BSF.4.32.0102282000210.97443-100000@zoraida.reyes.somos.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anthony Metzidis 2001-03-01 01:39:59 PG_PWD and PG_SHADOW
Previous Message Rod Taylor 2001-02-28 23:53:05 Re: 7.0 vs 7.1 running select count(*) FROM table WHERE (SELECT count(*) ) > 0;