Final notes

PostgreSQL allows defining objects of almost any kind supported by the PostgreSQL server (functions, aggregates, types, languages and foreign data wrappers no more remain just metadata, but become objects residing in the database). PostgreSQL’s ability to embrace external functionality opens up tremendous possibilities for application development. The standard PostgreSQL distribution is not limiting, and PostgreSQL installations can be enhanced in several ways.

The SQL extensibility of PostgreSQL is greatly facilitated by the design of the PostgreSQL execution HQJLQH, whLFh LV FDWDORJXH-GrLvHQ. UQOLNH VWDQGDrG relational database systems, PostgreSQL stores information about data-types, functions, operators, procedural languages, access methods, etc, in catalogues, which are similar to tables containing users' data. Various Data Definition Language (DDL) commands change these catalogues, thus extending or modifying the existing functionality.

Proper access permissions must be administered to prevent misuse of the extensions, which could compromise security or affect performance. Bad constructs and unoptimised queries can lead to slower functions, and thus bad performance.

PostgreSQL is a powerful solution, with a variety of IHDWXrHV WhDW DrH flHxLEOH, HxWHQVLEOH DQG HPSRwHrLQJ IRr anyone.