On Fri, 2005-09-23 at 13:19 +0200, Arjen van der Meijden wrote:
> Another suggestion:
> How many indexes and constraints are on the new table?
As mentioned in the first mail: in this tables only primary key
constraints, no other indexes or constraints.
> Drop all of them and recreate them once the table is filled. Of course
> that only works if you know your data will be ok (which is normal for
> imports of already conforming data like database dumps of existing tables).
> This will give major performance improvements, if you have indexes and
> such on the new table.
I will test this a for perfomance improvement, but still, I wonder if ~
100 inserts/second is a reasonable performance for my software/hardware
tel: 024-3888063 / 06-51855277
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2005-09-23 13:40:08|
|Subject: Re: optimization downgrade perfomance? |
|Previous:||From: Merlin Moncure||Date: 2005-09-23 12:34:21|
|Subject: Re: SELECT LIMIT 1 VIEW Performance Issue|