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 20040813111649.7B4116C4F8@tino.sinectis.com.ar
Whole thread Raw
In response to insert  (Ulrich Wisser <ulrich.wisser@relevanttraffic.se>)
List 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@uolsinectis.com.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


pgsql-performance by date:

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