Cursors and prepared statements are not supported.

Function parameters are not yet passed to the autonomous worker.

Transaction and error handling is limited compared to regular PL/pgSQL.

Data access is limited to the same database.

Memory usage increases with an additional backend process.

Launching the worker adds startup overhead.