Re: insertion becoming slow

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: insertion becoming slow
Date: 2005-09-26 17:58:41
Message-ID: 20050926175841.GK30974@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raj Gupta 2005-09-26 18:02:48 Re: Error migrating from 7.4.3 to 8.0.3
Previous Message Yonatan Ben-Nes 2005-09-26 17:56:33 Re: Slow search.. quite clueless