Rafia Sabih

postgres_fdw is the standard way to query remote PostgreSQL servers, but every scan uses a cursor, and cursors prevent the remote server from using parallel query plans. For large analytical queries, this means leaving significant performance on the table.

Postgresql has a special way of handling memory management, which is via specialized data structure called memory context. All the memory allocation and deallocation are done using a memory context.

In PostgreSQL, one of the key components is its query executor which is really in charge of running your query. This presentation will deep dive into this vital component of PostgreSQL and shed some light on the inner workings of the very heart of PostgreSQL.