The original server was running 9.5.14 The system I am currently testing on is 11.8
2 fields are marked as 'extended'. However if I understand correctly the table isn't actually toasted: oid | table_schema | table_name | total_bytes | total | index | toast | table -------+--------------------+-------------------------+--------------+------------+------------+------------+------------ 19601 | public | file | 147648061440 | 138 GB | 57 GB | 8192 bytes | 80 GB On Fri, May 22, 2020 at 3:58 PM Andreas Kretschmer <andr...@a-kretschmer.de> wrote: > > > Am 22.05.20 um 14:37 schrieb Nico De Ranter: > > Postgres version: 9.5 > > which minor-version? > > Can you check if the table has TOAST-Tables? Can you try to select all > columns but not TOASTed columns? > Maybe there is data-corruption only in toast-tables. > > > Regards, Andreas > > -- > 2ndQuadrant - The PostgreSQL Support Company. > www.2ndQuadrant.com > > > > -- Nico De Ranter Operations Engineer T. +32 16 38 72 10 <http://www.esaturnus.com> <http://www.esaturnus.com> eSATURNUS Philipssite 5, D, box 28 3001 Leuven – Belgium T. +32 16 40 12 82 F. +32 16 40 84 77 www.esaturnus.com <http://www.esaturnus.com/> *For Service & Support :* Support Line Belgium: +32 2 2009897 Support Line International: +44 12 56 68 38 78 Or via email : medical.services...@sony.com
