Closed helloiamlukas closed 1 year ago
settings
from json to jsonb in asset containers table.data
from json to jsonb in assets meta table.data
from json to jsonb in blueprints table and added a unique index on handle and namespace columns together as they are used for querying data by both fields combined (handle,namespace). Yes, you are right. I removed them now. Thanks for the hint!
To improve perfomance for Postgres databases, the
json
columns can use thejsonb
data type.This is will reduce responsetimes drastically when dealing with large datasets.