2011/7/20 Tom Lane <tgl@xxxxxxxxxxxxx>: > Ken Caruso <ken@xxxxxxxxx> writes: >> On Sun, Jul 17, 2011 at 3:04 AM, Cédric Villemain < >> cedric.villemain.debian@xxxxxxxxx> wrote: >>>> Block number 12125253 is bigger that any block we can find in >>>> base/2651908/652397108.1 > >>> Should the table size be in the 100GB range or 2-3 GB range ? > >> The DB was in the 200GB-300GB range when this happened. > > Cédric was asking about the particular table's size, not the whole DB... > the table in question is the one with relfilenode = 652397108. Yes, the error origin is probably due to faillure outside PostgreSQL. It should not happen but... well I was wondering how a table can be, by error, partially truncated (truncation of segment, not the sql TRUNCATE) by PostgreSQL... -- Cédric Villemain +33 (0)6 20 30 22 52 http://2ndQuadrant.fr/ PostgreSQL: Support 24x7 - Développement, Expertise et Formation -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
