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