Inserts taking exponentially longer as table size grows
We have seen a strange situation with postgres 8.3.6 taking longer times for inserting a fixed amount of data. The insertion time is increasing as the data in the table is growing. We tried to use COPY command but to no avail. The increase is also not linear. Insert is one of the basic operations. I am surprised to run into it on a fairly well established platform.
_________________________________________________________________
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