Re: [HACKERS] strange behavior of UPDATE

Edmund Mergl <E.Mergl@bawue.de> writes:
>> Could you try the same queries with no indexes in place, and see what
>> the time scaling is like then?  That would confirm or deny the theory
>> that it's an index-update problem.

> here they are, and yes, I double-checked them twice !

>   database         #rows      inserts    create      make_sqs    make_nqs
>                                           index      selects     updates
> ----------------------------------------------------------------------------
>     pgsql         10.000       00:24        -         00:13       00:05
>     pgsql        100.000       04:01        -         00:83       00:32
>     pgsql      1.000.000       39:24        -         26:36       26:52

Oh dear ... so much for my theory that index updates are to blame for
the scaling problem.  Back to the drawing board ...
        regards, tom lane