Results of 1 - 3 of about 3 for acquire (0.001 sec.)
- PostgreSQL Extension Functions 11570
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...attached catalogs without changing their configuration. Must be specified and non-NULL when any other option is specified. acquire_mode ( VARCHAR , default: 'force' ): how to acquire connections from the pool: 'force' (always connect, ignore pool limit).... Returns A table with the following columns: catalog_name ( VARCHAR ): the name (alias) of the attached Postgres database acquire_mode ( VARCHAR ): how to acquire connections from the pool: 'force' (always connect, ignore pool limit), 'wait' (block unt...ait when acquiring a connection from a pool where all available connections are already taken; only applicable to the wait acquire-mode cache_hits ( UBIGINT ): number of times a cached connection was successfully returned from the pool cache_misses ( UB... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- PostgreSQL Extension Connection Pool 9301
- PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive
...when the connection pool is configured to allow opening additional connections when all connection slots are taken ( force acquire mode), the addtional parallel queries are always use the try mode. If connection for them is not available (the maximum nu...does not participate futher in the processing of this table scan, that proceeds with the worker threads that were able to acquire a connection from the pool. See the description of the postgres_configure_pool function for details. Connection Proxies Co...connection pool for a database that is already attached the postgres_configure_pool function can be used instead. pg_pool_acquire_mode ( VARCHAR , default: 'force' ): how to acquire connections from the pool: 'force' (always connect, ignore pool limit)... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- MySQL Extension 7013
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...nections true mysql_incomplete_dates_as_nulls Whether to return DATE s with a zero month or day as NULL s false mysql_pool_acquire_mode How to acquire connections from the pool: force (always connect, ignoring the pool limit), wait (block until one is a... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work