RESTORE IS TO SLOW

Поиск
Список
Период
Сортировка
От marvin.deoliveira
Тема RESTORE IS TO SLOW
Дата
Msg-id 1316125973378-4808653.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: RESTORE IS TO SLOW
Список pgsql-admin
Hi.
I'm restoring a database (only rows) that has some tables with 9 millions
rows and others have even more.
It's going to slow ( more than 24 hours by now ).
I'm disabling the triggers but I guess if I drop the indexes it will have
more performance. Am I right?
If yes, does anyone have a script that generates the drop and create
indexes?






-----
Marcos Oliveira
And I still haven't found what I'm looking for...
--
View this message in context: http://postgresql.1045698.n5.nabble.com/RESTORE-IS-TO-SLOW-tp4808653p4808653.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: database size much bigger than tablespaces on filesystem
Следующее
От: Lonni J Friedman
Дата:
Сообщение: Re: RESTORE IS TO SLOW