-
Notifications
You must be signed in to change notification settings - Fork 0
Open
Labels
MaintenanceBehind-the-scenes improvements for security and longevityBehind-the-scenes improvements for security and longevity
Description
there are two schemas in the sprout-data db imports and independent
which may be unused. If we can confirm these are not needed, we can drop the schemas, and the nightly refresh schemas
from Gregor in slack
SELECT
n.nspname AS "Schema",
pg_size_pretty(SUM(pg_total_relation_size(c.oid))) AS "Size"
FROM
pg_class c
LEFT JOIN
pg_namespace n ON n.oid = c.relnamespace
WHERE
n.nspname in ('imports', 'independent')
GROUP BY
n.nspname;
gives 7664 kb for independent and 8192 bytes for imports
update create scripts to comment out and archive
https://github.com/cssat/sprout-data-db-cron/tree/main/sql/create
remove the refresh scripts and drop the schemas
https://github.com/cssat/sprout-data-db-cron/tree/main/sql/refresh
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
MaintenanceBehind-the-scenes improvements for security and longevityBehind-the-scenes improvements for security and longevity