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@xxxxxxxxxxxxxxx <mailto:andreas@xxxxxxxxxxxxxxx>> 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@xxxxxxxx
<mailto:medical.services.eu@xxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
