Re: >24 hour restore

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: >24 hour restore
Дата
Msg-id 20030529061818.GA23596@nordlb.lv
обсуждение исходный текст
Ответ на >24 hour restore  ("Chad Thompson" <chad@weblinkservices.com>)
Список pgsql-performance
* Chad Thompson <chad@weblinkservices.com> [28.05.2003 19:08]:
> I hope this is something easy/stupid that I have missed.  I know that w/
> mirroring my write times are not improved, but they are DEFINATLY not this
> bad.

Well, I have had something similar to your case, except for size - it's was
about 1 Gb.

I've dropped all foreign keys, triggers and, also, all indexes. As I've
found, each index takes additional time for inserts/updates/deletes,
so it's recommended to create indexes after data manipulations.

If this will not help, I don't know. May be hardware problems...

--

Victor Yegorov

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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: IN list processing performance (yet again)
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: IN list processing performance (yet again)