Re: [BUGS] Inserts taking exponentially longer as table size grows

2009-12-15 Thread Kevin Grittner
postgres bee 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.p

[BUGS] Inserts taking exponentially longer as table size grows

2009-12-15 Thread postgres bee
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 oper