performance while importing a very large data set in to database

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

 



Hello Everyone,

 

I have a very bit big database around 15 million in size, and the dump file is around 12 GB.

While importing this dump in to database I have noticed that initially query response time is very slow but it does improves with time.

Any suggestions to improve performance after dump in imported in to database will be highly appreciated!

 

 

 

Regards,

Ashish


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux