Presented by:
Andries Vorster
Developer / DevOps Manager / Father of 2 / Postgres Fanatic
I love Postgres , it can do just about anything.
I love optimising queries, automating stuff with Postgres.
No video of the event yet, sorry!
Introduction
Explanation of Extension Modules
- What are contrib modules and where can we find them ?
- List of contrib modules , a whole list of cool ready to install modules that would make your life easier.
- Installing Extensions
file_fdw
- Installation of extension
- Using extension module
- Examples
pgstatstatements
- Installation of extension
- config of extension
- using extension
- Examples
pg_trgm
- Installation of extension
- Using new opreators and functions
- New type indexes that can be created
- Examples
dblink
- Installation of extension
- basic explanation of dblink / dblink_connect / dblink_disconnect
- Examples
postgres_fdw
- Installation of extension
- Creating a foreign server
- Creating user mappings for the foreign server
- Creating foreign tables
- Importing foreign Schemas
- select/ update / delete possibilities when using postgres_fdw
- Examples
Q/A
- Date:
- 2019 October 8 11:20 SAST
- Duration:
- 40 min
- Room:
- Ballroom
- Conference:
- South Africa 2019
- Language:
- Track:
- Ops and Administration
- Difficulty:
- Medium