pg_migrator alpha 5 - truncates at 10 M rows

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.
    8.3        8.4cvs| rowcount  | rowcount |+-----------+----------+|  7708808  |  7708808 || 10189986  |  9826926 ||
2598808 |  2598808 ||  6074119  |  6074119 || 13563559  |  9830128 || 13597969  |  9830114 || 23507096  |  9829964 ||
15517779 |  9805163 || 12618858  |  9829974 || 11127521  |  9829902 ||  4728763  |  4728763 ||  4728763  |  4728763 ||
61193699 |  9173790 ||  1968328  |  1968328 || 53213115  |  9823165 || 31601320  |  9830060 |
 


One complication: I hadn't noticed
that there were 2 tables with a not yet
installed datatype.  These tables were
simply not created by the pg_migrator-run.

I don't know how this influenced the results,
but I'll repeat it in the coming days.



Erik Rijkers