On 12/13/06, Steven Flatt <steven(dot)flatt(at)gmail(dot)com> wrote:
> Our application is using Postgres 7.4 and I'd like to understand the root
> cause of this problem:
> To speed up overall insert time, our application will write thousands of
> rows, one by one, into a temp table
1. how frequently are you commiting the transaction ?
if you commit less frequetly it will be faster.
2. If you use COPY instead of INSERT it will be faster.
using COPY is easy with DBD::Pg (perl). In versions
8.x i think there has been major speed improvements
I do not know the root cause of slowdown though.
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2006-12-13 17:29:18|
|Subject: Re: Insertion to temp table deteriorating over time |
|Previous:||From: Arnaud Lesauvage||Date: 2006-12-13 16:47:20|
|Subject: Re: Slow update with simple query|