slow building index and reference after Sybase to Pg

Поиск
Список
Период
Сортировка
От Gary Fu
Тема slow building index and reference after Sybase to Pg
Дата
Msg-id ik3jps$28nf$1@news.hub.org
обсуждение исходный текст
Ответы Re: slow building index and reference after Sybase to Pg  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: slow building index and reference after Sybase to Pg  (Andy Colson <andy@squeakycode.net>)
Re: slow building index and reference after Sybase to Pg  (Andres Freund <andres@anarazel.de>)
Список pgsql-general
Hi,

I'm testing on converting a big Sybase db to Pg.  It took about 45 hours
to convert all sybase tables (bcp) to Pg (copy) without index and
reference.  After that I built the index (one by one, sequentially) and
it took about 25 hours and then I started to add the references (one by
one), however, it has been more than 30 hours and still has no sign of
finishing. I wonder, is there any suggestion that may speed up the index
and reference building (on Pg).

Thanks,
Gary

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

Предыдущее
От: akp geek
Дата:
Сообщение: Re: select to_timestamp('02/26/2011 14:50', 'MM/DD/YYYY HH24MI')
Следующее
От: "For@ll"
Дата:
Сообщение: Backup WAL files and pg_standby