Re: pg_migrator and an 8.3-compatible tsvector data type

Bruce,

> So, one idea would be, instead of a cast, have pg_migrator rebuild the
> tsvector columns with ALTER TABLE, so then the 8.4 index code could be
> used.  But then we might as well just tell the users to migrate the
> tsvector tables themselves, which is how pg_migrator behaves now.

It would be nice to have pg_migrator handle this, especially if we could 
do it in parallel.  Then we just have to warn users that migrating a 
database with tsvector columns takes significantly longer.  That is,

1) do rest of catalog swap and link/copy of objects.
2) mark all tsvector columns as 83_tsvector and add new tsvector type   (these columns will be unusable for queries)
3) bring up database
4) search for all 83_tsvector columns
5) do ALTER TABLE on each of these columns, in parallel, up to a 
configuration setting (default 3).

However, I can also understand not having time to implement the above 
before 8.4 release.


-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com