On Tue, Nov 5, 2013 at 2:52 PM, Leonardo Francalanci <m_li...@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). -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers