Re: pg_migrator alpha 5 - truncates at 10 M rows

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Erik Rijkers <er(at)xs4all(dot)nl>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_migrator alpha 5 - truncates at 10 M rows
Date: 2009-05-12 20:16:02
Message-ID: 200905122016.n4CKG7005123@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
> Tom Lane wrote:
> > "Erik Rijkers" <er(at)xs4all(dot)nl> writes:
> > > On Sun, May 10, 2009 02:05, Alvaro Herrera wrote:
> > >> I'm wondering that it could have forgotten to migrate the later table
> > >> segments ...
> >
> > > It seems al 'truncated' tables give
> > > pg_relation_size(oid) = 1073741824
> >
> > Looks like Alvaro nailed it. Bruce, you reading?
>
> Yes, will research; thanks. I know we have multi-segment code, but
> obviously it is not working reliably.

I have fixed pg_migrator's multi-segment code and have released an
alpha-6 that fixes all known bugs:

http://pgfoundry.org/frs/?group_id=1000235

--
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. +

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2009-05-12 20:17:24 Re: pg_migrator alpha 5 - truncates at 10 M rows
Previous Message Alex Hunsaker 2009-05-12 18:10:08 Re: DROP TABLE vs inheritance