6000 inserts, each in its own transaction, will be very long.
Group your inserts in one transaction and it'll be faster (maybe 1-2
minutes).
Have your program generate a tab-delimited text file and load it with
COPY, you should be down to a few seconds.
On Tue, 21 Sep 2004 13:27:43 +0200,
On Tue, 21 Sep 2004, Alain Reymond wrote:
> I created a database with Postgres 7.3.4 under Linux RedHat 7.3 on a
> Dell PowerEdge server.
You should probably upgrade to the end of the 7.3 branch at the least
(7.3.7).
> One of the table is
> resultats(numbil, numpara, mesure, deviation)
> with a
Am 21.09.2004 13:27 schrieb Alain Reymond:
>
> Do you have any idea how I can improve speed - apart from splitting
> the table every 2 or 3 years which is the the aim of a database!
>
Drop the index before you insert the data and recreate it afterwards.
Use the "copy from ..." command instead
Good afternoon,
I created a database with Postgres 7.3.4 under Linux RedHat 7.3 on a
Dell PowerEdge server.
One of the table is
resultats(numbil, numpara, mesure, deviation)
with an index on numbil.
Each select on numbil returns up to 60 rows (that means 60 rows for
one numbil with 60 differ
