Rajesh Kumar Mallah wrote:
> 4. fsync can also be turned off while loading huge dataset ,
> but seek others comments too (as study docs) as i am not sure about the
> reliability. i think it can make a lot of difference.
Also be sure to increase maintenance_work_mem so that index creation
goes faster.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support