From: gnari <gnari@simnet.is>
To: gbarosio@uolsinectis.com.ar
To: pgsql-performance@postgresql.org
Subject: Re: insert
Date: Fri, 13 Aug 2004 11:47:27 -0000
Message-ID: <00cc01c4812b$4e7f02e0$0100000a@wp2000> (raw)
References: <20040813111649.7B4116C4F8@tino.sinectis.com.ar>
From: "G u i d o B a r o s i o" <gbarosio@uolsinectis.com.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@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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gnari@simnet.is, gbarosio@uolsinectis.com.ar
Subject: Re: insert
In-Reply-To: <00cc01c4812b$4e7f02e0$0100000a@wp2000>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox