Skip site navigation (1) Skip section navigation (2)

Inserts taking exponentially longer as table size grows

From: postgres bee <postgres_bee(at)live(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: Inserts taking exponentially longer as table size grows
Date: 2009-12-15 19:30:44
Message-ID: BLU139-W1057D3432065A78BBB0D3A85880@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-bugs
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/

Responses

pgsql-bugs by date

Next:From: Stefan KaltenbrunnerDate: 2009-12-15 19:34:14
Subject: Re: BUG #5242: ODBC driver v8.4.1 crashed
Previous:From: Alvaro HerreraDate: 2009-12-15 19:28:00
Subject: Re: BUG #5242: ODBC driver v8.4.1 crashed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group