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

Reply via email to