But PostgreSQL can handle it? Does it have good search performance? and is memory usage feasible?
Images of that size won’t be stored on the main table so performance when not asking for image data should be normal. Memory is one of those usage patterns and hardware “it depends” things. Probably it will be OK.
Personally, it is easier, and less complex, than the alternative. Do it and migrate later if issues arise.
David J.
