On Mon, Jan 30, 2012 at 9:46 AM, Saurabh <saurabh.b85@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
