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: gnari(at)simnet(dot)is, pgsql-performance(at)postgresql(dot)org
Subject: Re: insert
Date: 2004-08-13 11:16:49
Message-ID: 20040813111649.7B4116C4F8@tino.sinectis.com.ar (view raw or flat)
Thread:
Lists: pgsql-performance
As I see it's 100 inserts every 5 minutes, not only 100 inserts.

Sure it's extreme for only 100 inserts.

Cheers,
Guido

> "G u i d o B a r o s i o" <gbarosio(at)uolsinectis(dot)com(dot)ar> wrote:
> 
> [speeding up 100 inserts every 5 minutes]
> 
> > Tips!
> > *Delete indexes and recreate them after the insert.
> 
> sounds a bit extreme, for only 100 inserts
>  
> gnari
> 
> 
> 
> 
> 
> ---------------------------(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 11:47:27
Subject: Re: insert
Previous:From: gnariDate: 2004-08-13 10:49:05
Subject: Re: insert

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