Re: insertion becoming slow
| От | Jim C. Nasby |
|---|---|
| Тема | Re: insertion becoming slow |
| Дата | |
| Msg-id | 20050926175841.GK30974@pervasive.com обсуждение исходный текст |
| Ответ на | insertion becoming slow ("surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in>) |
| Ответы |
Re: insertion becoming slow
Re: insertion becoming slow |
| Список | 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 по дате отправления: