From: Gaetano Mendola <mendola@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: insert
Date: Sat, 14 Aug 2004 16:24:08 +0200
Message-ID: <cfl7c8$f9a$2@floppy.pyrenet.fr> (raw)
In-Reply-To: <009c01c48123$270f7760$0100000a@wp2000>
References: <20040813100800.24FC86C37F@honorio.sinectis.com.ar>
<009c01c48123$270f7760$0100000a@wp2000>
gnari wrote:
> "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
which fsync method are you using ?
change it and see what happen
Regards
Gaetano Mendola
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: mendola@bigfoot.com
Subject: Re: insert
In-Reply-To: <cfl7c8$f9a$2@floppy.pyrenet.fr>
* 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