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

Re: insert

From: G u i d o B a r o s i o <gbarosio(at)uolsinectis(dot)com(dot)ar>
To: ulrich(dot)wisser(at)relevanttraffic(dot)se,pgsql-performance(at)postgresql(dot)org
Subject: Re: insert
Date: 2004-08-13 10:08:00
Message-ID: 20040813100800.24FC86C37F@honorio.sinectis.com.ar (view raw or flat)
Thread:
Lists: 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


Responses

pgsql-performance by date

Next:From: gnariDate: 2004-08-13 10:49:05
Subject: Re: insert
Previous:From: Ulrich WisserDate: 2004-08-13 07:47:17
Subject: insert

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