postgresml/pgcat

Outdated Documentation

Opened this issue · 0 comments

In the README says pgcat don't support prepared statement on transaction pooling mode.

pgcat/README.md

Line 144 in 0b034a6

In transaction mode, a client talks to one server for the duration of a single transaction; once it's over, the server is returned to the pool. Prepared statements, `SET`, and advisory locks are not supported; alternatives are to use `SET LOCAL` and `pg_advisory_xact_lock` which are scoped to the transaction.

After reading that I removed pgcat from my research list, but then I accidentally found the PostgresML doc page, where there are configuration parameters to enable prepared statement on transaction and session mode.

Would also be nice to have the PostgresML pgcat product page linked in the repo.