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

Re: insert

From: "gnari" <gnari(at)simnet(dot)is>
To: <gbarosio(at)uolsinectis(dot)com(dot)ar>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: insert
Date: 2004-08-13 11:47:27
Message-ID: 00cc01c4812b$4e7f02e0$0100000a@wp2000 (view raw or flat)
Thread:
Lists: pgsql-performance
From: "G u i d o B a r o s i o" <gbarosio(at)uolsinectis(dot)com(dot)ar>:


> As I see it's 100 inserts every 5 minutes, not only 100 inserts.
>
> Sure it's extreme for only 100 inserts.

I am sorry, I do not quite grasp what you are saying.
my understanding was that there are constantly new inserts,
coming in bursts of 100 , every 5 minutes.
I imagined that the indexes were needed in between.

if this is the case, the bunches of 100 inserts should
be done inside a transaction (or by 1 COPY statement)

if, on the other hand, the inserts happen independently,
at a rate of 100 inserts / 5 minutes, then this will not help

gnari



>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>


In response to

  • Re: insert at 2004-08-13 11:16:49 from G u i d o B a r o s i o

Responses

  • Re: insert at 2004-08-13 12:10:11 from Ulrich Wisser

pgsql-performance by date

Next:From: Ulrich WisserDate: 2004-08-13 12:10:11
Subject: Re: insert
Previous:From: G u i d o B a r o s i oDate: 2004-08-13 11:16:49
Subject: Re: insert

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