Table bloat query failing on PG 12

ioguix / pgsql-bloat-estimation

Queries to mesure statistical bloat in indexes and tables for PostgreSQL

BSD 2-Clause "Simplified" License

515 stars 94 forks source link

Table bloat query failing on PG 12 #10

Closed kmoppel closed 4 years ago

kmoppel commented 5 years ago

Hi, currently table bloat query breaks due to removal of pg_class.relhasoids. I think best would be to just remove this part as it's been a deprecated feature for long time so only precision for system catalogs could suffer a bit, but they should be small anyways.

ioguix commented 5 years ago

Hi,

I prefer to keep the reverse compatibility with older pgsql release.

Either I create a new table-bloat-9.0-11.sql and the new table-bloat.sql supports v12 and newer or I fix the current query.

See #11 as a solution for the later. Test and feedback would be appreciated.

Thank you for the report.

ioguix commented 5 years ago

Fixed in #11. Thank you!