slony issues.

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема slony issues.
Дата
Msg-id dcc563d10911070823v6d679b3bj2a7dbeaf7f5c8bf0@mail.gmail.com
обсуждение исходный текст
Ответы Re: slony issues.
Список pgsql-general
I already asked this basic question on the slony mailing lists, but
they seem kinda quiet this week.

So, I've got a database with about 30,000 objects in it, and running
the setaddtable() function is taking about 30 seconds, and spinning a
CPU 100% while doing it.  Any suggestions on indexes, or changing
functional costs to get this to run in a more reasonable time.  I'm
adding about 600 tables and 200 sequences, and with each table taking
30 seconds it's taking about 5 hours to create a set, which is just
crazy to me.  On a much slower machine but without the other 29,000 or
so objects, each table takes around 5 to 10 seconds to add, which is
still long, but not quite as long as on my production server.

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

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: WAL shipping to two machines (PITR)
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: slony issues.