Re: Porting from MS SQL Server to PostGres

Поиск
Список
Период
Сортировка
От Rosser Schwarz
Тема Re: Porting from MS SQL Server to PostGres
Дата
Msg-id 37d451f704092413573a5ea4e0@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Porting from MS SQL Server to PostGres  ("Goulet, Dick" <DGoulet@vicr.com>)
Список pgsql-admin
while you weren't looking, Goulet, Dick wrote:

>  I'd precreate all of the tables/indexes and then move the data...

If you have a lot of data, it's probably better to punt on creating
the indices until after you've moved the data.  Bulk populating
indexed tables, particularly if the table has more than just the
primary key index, can be awfully slow.  At one point, we tried
dumping several million tuples into a table with a dozen-odd indices.
Only did that once.

/rls

--
:wq

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

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: tsearch2 poor performance
Следующее
От: Hemapriya
Дата:
Сообщение: View Different Schemas