Shawn Garbett <shawn_garbett@yahoo.com> writes:
> ... Or does the shared library get loaded
> separately for each process?
Effectively, yes. You can preload the library in the postmaster if
startup time is a big concern, but each backend process will have its
own instances of the static variables.
regards, tom lane