CODEWITHSUNDEEP
postgresqlasynchronousasyncpg
Marek Marczak
Marek Marczak

Reputation: 554

Asynchronous database queries in PostgreSQL using drivers

I would like to use asynchronous queries in PostgreSQL. I know that some asynchronous drivers exist in many programming languages ie. asyncg (Python), vertx-postgress (Java) and so on.

Do I need to configure PostgreSQL somehow to use asynchronous features? There is an "Asynchronous Behavior" section in postgesql.conf. Do I need to uncomment and edit these values to use PostgreSQL optimally in an asynchronous way?

Upvotes: 1

Views: 8560

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 246798

The parameters in the “asynchonous behavior” section of the documentation are largely unrelated.

You should instead study the Asynchronous Command Processing section. This is about the C library, but that's probably what's used by the libraries you mention under the hood.

Don't forget that there can only be one query at a time on a PostgreSQL database connection, regardless if processing is synchronous or not.

Upvotes: 11

Related Questions