-
-
Notifications
You must be signed in to change notification settings - Fork 19
Open
Labels
enhancementNew feature or requestNew feature or requestgood first issueGood for newcomersGood for newcomershelp wantedExtra attention is neededExtra attention is needed
Description
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
Labels
enhancementNew feature or requestNew feature or requestgood first issueGood for newcomersGood for newcomershelp wantedExtra attention is neededExtra attention is needed