Re: pg_migrator alpha 5 - truncates at 10 M rows - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pg_migrator alpha 5 - truncates at 10 M rows
Date
Msg-id 20090510000536.GC5365@alvh.no-ip.org
Whole thread Raw
In response to pg_migrator alpha 5 - truncates at 10 M rows  ("Erik Rijkers" <er@xs4all.nl>)
List pgsql-hackers
Erik Rijkers wrote:
> 2009.05.09
> 
> pg_migrator alpha 5 results
> from PostgreSQL 8.3.7 to 8.4cvs
> 
> Centos 5.2 x86_64 GNU/Linux
> 
> pg_migrator ran without errors.
> 
> Of 120 tables, all smaller tables
> have the correct rowcount, but all
> larger tables are 'truncated' at
> around 10 million rows.  I haven't
> looked at table content.

Can you please show
SELECT relname, pg_relation_size(oid) FROM pg_class
for your tables?

I'm wondering that it could have forgotten to migrate the later table
segments ...

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: HashJoin w/option to unique-ify inner rel
Next
From: "damien@dalibo.info"
Date:
Subject: Re: Have \d show child tables that inherit from the specified parent