Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux