Postgres Pro
Downloads
Home   >   mailing lists

performance while importing a very large data set in to database - Mailing list pgsql-performance

From Ashish Kumar Singh
Subject performance while importing a very large data set in to database
Date
Msg-id 4E4BE0891B34364AAA883AC3F85CF86803870DCC@blrex.prog.altair.com
Whole thread Raw
Responses Re: performance while importing a very large data set in to database
Re: performance while importing a very large data set in to database
Re: performance while importing a very large data set in to database
List pgsql-performance
Tree view

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

pgsql-performance by date:

Previous
From: niraj patel
Date:
Subject: Time Profiling inside the procedure
Next
From: Andreas Thiel
Date:
Subject: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum