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