Question
CREATE EXTENSION versus loading a shared library: what differs, and when is each required?
Answer
CREATE EXTENSION installs database-local SQL objects and records them as an extension. shared_preload_libraries loads server libraries at startup for modules requiring shared-memory or startup hooks. Use CREATE EXTENSION for installed functionality; configure preload and restart where the module requires it.