Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows
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 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 br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows
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 so that an error on schema restore will be displayed to the user and pg_migrator will exit with an error. FYI, the multi-segment bug you reported is fixed in a new alpha-6 release too. Thanks for the testing and the report. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows
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 it. Bruce, you reading? Yes, will research; thanks. I know we have multi-segment code, but obviously it is not working reliably. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows
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 Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows
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 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 ... In the following list, I have put count(*) of each table next to the pg_relation_size(oid) from pg_class: It seems al 'truncated' tables give pg_relation_size(oid) = 1073741824 (not the same subset as in previous mail) | v 8.3.7 | 8.4 cvs head | count(*) | pg_relation_size(oid) | count(*) | pg_relation_size(oid) +--+--- ---+--+-- | 15 | 8192 | 15 | 8192 | 7708808 | 842334208 | 7708808 | 842334208 | 10189986 |1113432064 | 9826926 |1073741824 | 2598808 | 284360704 | 2598808 | 284360704 | 6074119 | 663576576 | 6074119 | 663576576 | 13563559 |1481555968 | 9830128 |1073741824 | 13597969 |1485307904 | 9830114 |1073741824 | 23507096 |2567831552 | 9829964 |1073741824 | 15517779 |1699192832 | 9805163 |1073741824 | 12618858 |1378377728 | 9829974 |1073741824 | 11127521 |1215488000 | 9829902 |1073741824 | 56 | 16384 | 56 | 16384 | 12667465 |1278066688 | 10647510 |1073741824 | 4728763 |1623310336 | 4728763 | 553402368 | 4728763 | 553402368 | 4728763 | 553402368 | 10 | 8192 | 10 | 8192 | 100 | 16384 | 100 | 16384 | 13843420 |1620082688 | 9175040 |1073741824 | 1523927 | 215244800 | 1523927 | 215244800 | 1614576 | 219340800 | 1614576 | 219340800 | 61193699 |7162437632 | 9173790 |1073741824 | 1968328 | 215367680 | 1968328 | 215367680 | 53213115 |5817516032 | 9823165 |1073741824 | 31462058 |3440214016 | 9821425 |1073741824 | 31601320 |3451863040 | 9830060 |1073741824 hth, Erik Rijkers -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] pg_migrator alpha 5 - truncates at 10 M rows
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? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers