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