Re: insert - Mailing list pgsql-performance

From G u i d o B a r o s i o
Subject Re: insert
Date
Msg-id 20040813100800.24FC86C37F@honorio.sinectis.com.ar
Whole thread Raw
In response to insert  (Ulrich Wisser <ulrich.wisser@relevanttraffic.se>)
List pgsql-performance
Tips!
*Delete indexes and recreate them after the insert.
*Disable auto-commit
*Perform a copy will be faster, sure.

Best wishes,
Guido

> Hi,
>
> is there anything I can doo to speed up inserts? One of my tables gets
> about 100 new rows every five minutes. And somehow the inserts tend to
> take more and more time.
>
> Any suggestions welcome.
>
> TIA
>
> Ulrich
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match


pgsql-performance by date:

Previous
From: Ulrich Wisser
Date:
Subject: insert
Next
From: "gnari"
Date:
Subject: Re: insert