Hannu Krosing <[EMAIL PROTECTED]> writes:
> Ãhel kenal päeval, K, 2007-03-21 kell 17:25, kirjutas Bruce Momjian:
>> Added to TODO:
>> o During index creation, pre-sort the tuples to improve build speed
> Maybe the TODO text should mention, that it is about HASH indexes ?
It's under the hash-ind
Hannu Krosing wrote:
> ?hel kenal p?eval, K, 2007-03-21 kell 17:25, kirjutas Bruce Momjian:
> > Added to TODO:
> >
> > o During index creation, pre-sort the tuples to improve build speed
> >
> > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php
>
> Maybe the TODO
Ühel kenal päeval, K, 2007-03-21 kell 17:25, kirjutas Bruce Momjian:
> Added to TODO:
>
> o During index creation, pre-sort the tuples to improve build speed
>
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php
Maybe the TODO text should mention, that it is abou
Added to TODO:
o During index creation, pre-sort the tuples to improve build speed
http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php
---
Tom Lane wrote:
> I wrote:
> > I'm not sure if this
I wrote:
> I'm not sure if this has been discussed before, but I suddenly realized
> while responding to the above message that the reason for the awful
> performance is pretty obvious: hashbuild starts with a minimum-size
> index (two buckets) and repeatedly splits buckets as insertions are
> done
