Re: Insert performance vs Table size - Mailing list pgsql-performance

From Tom Lane
Subject Re: Insert performance vs Table size
Date
Msg-id 14991.1119968759@sss.pgh.pa.us
Whole thread Raw
In response to Re: Insert performance vs Table size  ("Praveen Raja" <praveen.raja@netlight.se>)
List pgsql-performance
"Praveen Raja" <praveen.raja@netlight.se> writes:
> I know that having indexes on the table adds an overhead but again does
> this overhead increase (for an INSERT operation) with the number of rows
> the table contains?

Typical index implementations (such as b-tree) have roughly O(log N)
cost to insert or lookup a key in an N-entry index.  So yes, it grows,
though slowly.

            regards, tom lane

pgsql-performance by date:

Previous
From: bsimon@loxane.com
Date:
Subject: Réf. : tricky query
Next
From: John A Meinel
Date:
Subject: Re: tricky query