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.
In response to
pgsql-admin by date
|Next:||From: Hemapriya||Date: 2004-09-24 21:31:58|
|Subject: View Different Schemas|
|Previous:||From: Oleg Bartunov||Date: 2004-09-24 17:20:36|
|Subject: Re: tsearch2 poor performance|