Re: are there any methods to disable updating index before inserting large number tuples?

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: are there any methods to disable updating index before inserting large number tuples?
Дата
Msg-id 4ECBE35E.90105@hogranch.com
обсуждение исходный текст
Ответ на Re: are there any methods to disable updating index before inserting large number tuples?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Ответы Re: are there any methods to disable updating index before inserting large number tuples?  (Andres Freund <andres@anarazel.de>)
Список pgsql-general
Дерево обсуждения 
On 11/22/11 7:52 AM, Andrew Sullivan wrote:
> But I think performance on that table is going to be pretty bad.  I
> suspect that COPY is going to be your friend here.

indeed.  20M rows/hour is 5500 rows/second.  you'd better have a
seriously fast disk system, say, 20 15k RPM SAS drives in a RAID10 with
a decent SAS raid controller that has 1GB of writeback battery-or-flash
backed cache.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

В списке pgsql-general по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: possible race condition in trigger functions on insert operations?
Следующее
От: Kenneth Tilton
Дата:
Сообщение: Re: possible race condition in trigger functions on insert operations?