Slide 18 of 21
Notes:
- N active Users get N POSTGRES processes which share code
and all other resources, easier to implement then,
server/ multiple client model
- Parser, Optimizer, Executor are table-driven- system
catalog, info that is frequently used is cached for
better performance.
- Data Types, operators, and functions can be added and
subtracted dynamically
- aging used to maintain cache
- Dynamic loader is required for each hardware platform.
- POSTMASTER created to manage rule wake-up when markers
are present. It alerts the process that triggered the
rule and delivers the results to the application process.