Re: Porting from MS SQL Server to PostGres - Mailing list pgsql-admin

From Rosser Schwarz
Subject Re: Porting from MS SQL Server to PostGres
Date
Msg-id 37d451f704092413573a5ea4e0@mail.gmail.com
Whole thread Raw
In response to Re: Porting from MS SQL Server to PostGres  ("Goulet, Dick" <DGoulet@vicr.com>)
List 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 by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: tsearch2 poor performance
Next
From: Hemapriya
Date:
Subject: View Different Schemas