Re: insert

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: insert
Date: 2004-08-14 14:24:08
Message-ID: cfl7c8$f9a$2@floppy.pyrenet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

gnari wrote:

> "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

which fsync method are you using ?
change it and see what happen

Regards
Gaetano Mendola

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jan Wieck 2004-08-14 15:33:24 Re: Replication: Slony-I vs. Mammoth Replicator vs. ?
Previous Message Peter Eisentraut 2004-08-14 10:57:37 Re: [PERFORM] Reiser4