On Thu, Jul 28, 2016 at 02:23:18AM -0000, Greg Sabino Mullane wrote: > > Marc wrote: > > I donât have a 1TB database to try it on, mind you, so your > > âwait couple of daysâ might be *with* the âlink option? > > I think you mean *without*, but yeah, there is no way the --link > option is going to take that long. Hard links are awesome. We've upgraded > some really big databases, and --link is really, really fast. > If you can't use --link (usually because you want to get over > the checksum hump), we use something like Bucardo to help out. > No need to ever wait a "couple of days" as OP claims. :) > > What really bites is the analyze afterwards. That's the part > that takes too long (yes, --in-stages helps some). Would love > to see progress made there. Agreed. I will try to prioritize it. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
