Thread: Inserts taking exponentially longer as table size grows

We have seen a strange situation with postgres 8.3.6 taking longer times fo=
r inserting a fixed amount of data.  The insertion time is increasing as th=
e data in the table is growing.  We tried to use COPY command but to no ava=
il.  The increase is also not linear.  Insert is one of the basic operation=
s.  I am surprised to run into it on a fairly well established platform.
=20=09=09=20=09=20=20=20=09=09=20=20
_________________________________________________________________
Hotmail: Trusted email with powerful SPAM protection.
http://clk.atdmt.com/GBL/go/177141665/direct/01/=

postgres bee <postgres_bee@live.com> wrote:

> insertion time is increasing as the data in the table is growing.

You have given no indication that there is a bug.  Please re-post to
the performance list, but first you should read these pages (both
referenced in the description of the performance list):

http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

http://wiki.postgresql.org/wiki/SlowQueryQuestions

If you provide the suggested details, someone can probably help you;
not much chance of that with the vague description you've given so
far.  (Hint, slower inserts with larger tables is not a general
problem with PostgreSQL, we we need to figure out what specific
thing you're doing which causes this for you.)

-Kevin