Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows

2009-05-12 Thread Bruce Momjian
Bruce Momjian wrote: Tom Lane wrote: Erik Rijkers e...@xs4all.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

Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows

2009-05-12 Thread Bruce Momjian
Erik Rijkers wrote: 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. I have modified pg_migrator

Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows

2009-05-11 Thread Bruce Momjian
Tom Lane wrote: Erik Rijkers e...@xs4all.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

Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows

2009-05-09 Thread Alvaro Herrera
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

Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows

2009-05-09 Thread Erik Rijkers
On Sun, May 10, 2009 02:05, Alvaro Herrera wrote: 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

Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows

2009-05-09 Thread Tom Lane
Erik Rijkers e...@xs4all.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?

[HACKERS] pg_migrator alpha 5 - truncates at 10 M rows

2009-05-08 Thread Erik Rijkers
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.