performance while importing a very large data set in to database

Поиск
Список
Период
Сортировка
От Ashish Kumar Singh
Тема performance while importing a very large data set in to database
Дата
Msg-id 4E4BE0891B34364AAA883AC3F85CF86803870DCC@blrex.prog.altair.com
обсуждение исходный текст
Ответы Re: performance while importing a very large data set in to database  (Jeremy Harris <jgh@wizmail.org>)
Re: performance while importing a very large data set in to database  ("Ing . Marcos Luís Ortíz Valmaseda" <mlortiz@uci.cu>)
Re: performance while importing a very large data set in to database  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: niraj patel
Дата:
Сообщение: Time Profiling inside the procedure
Следующее
От: Andreas Thiel
Дата:
Сообщение: Large DB, several tuning questions: Index sizes, VACUUM, REINDEX, Autovacuum