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

Поиск
Список
Период
Сортировка
От sunpeng
Тема are there any methods to disable updating index before inserting large number tuples?
Дата
Msg-id CAOYKhLrpS0zZJcP_J_a8A-oSZnC5BX0krS42UzJoc+pgGkSSzQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: are there any methods to disable updating index before inserting large number tuples?  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-general
Дерево обсуждения
hi, friends,
  Now each hour I want to insert about 20 millions tuples into table A,  which has a  btree index.
  How to disable index update before inserting those 20 millions tuples, and then enable it after those tuples having being inserted? Just as the followings:
  >disable index update
  >insert into A ....//here will insert 20 millions tuples
  > enable index update

  The purpose is to improve the performance.
  Thanks!
peng

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Is this safe to perform on PostgreSQL 8.3.7 -> Resize a column in a PostgreSQL table without changing data
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: are there any methods to disable updating index before inserting large number tuples?