Re: insertion becoming slow - Mailing list pgsql-general

From Jim C. Nasby
Subject Re: insertion becoming slow
Date
Msg-id 20050926175841.GK30974@pervasive.com
Whole thread Raw
In response to insertion becoming slow  ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>)
Responses Re: insertion becoming slow
Re: insertion becoming slow
List pgsql-general
On Mon, Sep 26, 2005 at 05:55:18PM +0530, surabhi.ahuja wrote:
> i have seen that after insertion say (20 k rows) the insertion to tables becomes slow..why is it?

Most likely due to indexes.

> is there any way in which u can stop the performance from degrading

If you're loading from scratch, don't create the indexes until after the
load is done.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: ruben
Date:
Subject: Re: SQL command to dump the contents of table failed: PQendcopy()
Next
From: Oleg Bartunov
Date:
Subject: Re: Slow search.. quite clueless