Re: pg_migrator and an 8.3-compatible tsvector data type

Alvaro Herrera wrote:
> Tom Lane wrote:
>
> > People who want decent performance on partial match queries (or maybe
> > even *any* TS queries) are going to have to convert to the new format
> > anyway, though, so maybe this isn't something worth putting a whole lot
> > of work into. It might be sufficient if the database conversion
> > succeeds but leaves the tsvector columns unusable until they're
> > converted.
>
> There are so many caveats on pg_migrator (and things that need to be
> done after the migration is complete) that one starts to wonder if
> people is not better off just using parallel pg_restore. From Stefan's
> reported timings I'm not sure that pg_migrator is that much of a benefit
> in the first place ... unless copy mode can be made much faster. (On
> link mode it is so much faster that it's worth it, but then you don't
> have an escape hatch).

That is accurate. I doubt copy mode speed can be improved. I think
doing a backup, then using --link mode will be the most common usage
pattern.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +