On 5/22/20 7:48 AM, Nico De Ranter wrote:
> 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
What query are you using to get above?
>
>
> On Fri, May 22, 2020 at 3:58 PM Andreas Kretschmer
> <andreas@a-kretschmer.de <mailto:andreas@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 <http://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>
>
> ** <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.eu@sony.com
> <mailto:medical.services.eu@sony.com>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com