Re: insert - Mailing list pgsql-performance

From Gaetano Mendola
Subject Re: insert
Date
Msg-id cfl7c8$f9a$2@floppy.pyrenet.fr
Whole thread Raw
In response to Re: insert  ("gnari" <gnari@simnet.is>)
List pgsql-performance
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



pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Replication: Slony-I vs. Mammoth Replicator vs. ?
Next
From: Jan Wieck
Date:
Subject: Re: Replication: Slony-I vs. Mammoth Replicator vs. ?