Re: pg_migrator alpha 5 - truncates at 10 M rows

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 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-11 11:50:26
Message-ID: 200905111150.n4BBoQp07474@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dunia Ramazani 2009-05-11 13:34:35 Postgresql Developer
Previous Message Hans-Juergen Schoenig 2009-05-11 10:31:19 Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5