Skip to content

Add a check for tables with BLOB [schemacrawler] #635

@mfvanek

Description

@mfvanek

See similar check https://www.schemacrawler.com/lint.html

  • Linter: schemacrawler.tools.linter.LinterTooManyLobs
    Checks for tables that have too many large objects (CLOBs or BLOBs), since these could result in additional reads when returning query results.

See article https://www.enterprisedb.com/postgres-tutorials/postgresql-toast-and-working-blobsclobs-explained

Wee need to find all tables with oid column types:

CREATE TABLE imageslo (imgname text, imgoid oid);

It's better to use text/bytea types

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions