Re: Fast insertion indexes: why no developments - Mailing list pgsql-hackers

From Claudio Freire
Subject Re: Fast insertion indexes: why no developments
Date
Msg-id CAGTBQpYWRHAWfHtTxpd-_gzMFgbvVLcmmmr4fw0+MF=wc=FFEg@mail.gmail.com
Whole thread Raw
In response to Re: Fast insertion indexes: why no developments  (Leonardo Francalanci <m_lists@yahoo.it>)
List pgsql-hackers
On Tue, Nov 5, 2013 at 2:52 PM, Leonardo Francalanci <m_lists@yahoo.it> wrote:
> Jeff Janes wrote
>> Some experiments I did a few years ago showed that applying sorts to the
>> data to be inserted could be helpful even when the sort batch size was as
>> small as one tuple per 5 pages of existing index.  Maybe even less.
>
> Cool!!! Do you have any idea/hint on how I could try and replicate that?
> Do you remember how you did it?


I do it regularly by sorting tuples before inserting/updating. It
helps quite significantly for batches of ~1000 tuples (well, in my
case).



pgsql-hackers by date:

Previous
From: Leonardo Francalanci
Date:
Subject: Re: Fast insertion indexes: why no developments
Next
From: Josh Berkus
Date:
Subject: Re: List of "binary-compatible" data types