On Mon, Jan 30, 2012 at 9:46 AM, Saurabh <saurabh....@gmail.com> wrote: > I can not create the index after insertion because user can > search the data as well while insertion.
Remember, DDL is transactional in PostgreSQL. In principle, you should be able to drop the index, do your inserts, and re-create the index without affecting concurrent users, if you do all of that inside an explicit transaction. Doing the inserts inside a transaction may speed them up, as well. rls -- :wq -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
