Re: Bulk INSERT performance in 7.4.1
От | Vivek Khera |
---|---|
Тема | Re: Bulk INSERT performance in 7.4.1 |
Дата | |
Msg-id | x7r7w9smii.fsf@yertle.int.kciLink.com обсуждение исходный текст |
Ответ на | Bulk INSERT performance in 7.4.1 (Florian Weimer <fw@deneb.enyo.de>) |
Ответы |
Re: Bulk INSERT performance in 7.4.1
Re: Bulk INSERT performance in 7.4.1 |
Список | pgsql-performance |
>>>>> "FW" == Florian Weimer <fw@deneb.enyo.de> writes: FW> After increasing the number of checkpoint segments and the shared-memory FW> buffers, performance is back to the expected levels. It might even be a FW> bit faster. If you've got the time, could you try also doing the full bulk insert test with the checkpoint log files on another physical disk? See if that's any faster. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-301-869-4449 x806 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/
В списке pgsql-performance по дате отправления: