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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
