Results of 1 - 4 of about 4 for millis (0.001 sec.)
- PostgreSQL Extension Connection Pool 11335
- 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
...environments with connection proxies it may be better to set the idle timeout to a lower value (using pg_pool_idle_timeout_millis configuration option or postgres_configure_pool function) or to disable the pooling completely (by setting pg_pool_max_con..."reaper thread") that periodically scans idle connections in the pool and closes the ones of them that exceed idle_timeout_millis or max_lifetime_millis values. Separate thread is run for each connections pool, it can be enabled/disabled using pg_pool_...enable_reaper_thread configuraton option. When the reaper thread is not running, idle_timeout_millis or max_lifetime_millis values of the connections still can be checked, but they are only checked when a connection is take... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- PostgreSQL Extension Functions 10818
- 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
...pool for each attached Postgres database. This number can be temporary exceeded when parallel scans are used. wait_timeout_millis ( UBIGINT ): maximum number of milliseconds to wait when acquiring a connection from a pool where all available connection...pinned to the threads and are not made available to other threads, while still taking the place in the pool. max_lifetime_millis ( UBIGINT ): maximum number of milliseconds the connection can be kept open. This number is checked when the connection is...r thread is enabled ( enable_reaper_thread argument), then this number is checked in background periodically. idle_timeout_millis ( UBIGINT ): maximum number of milliseconds the connection can be kept idle in the pool. This number is checked when the c... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- MySQL Extension 7600
- 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.
...it (block until one is available), or try (fail immediately if none is available) force mysql_pool_connection_idle_timeout_millis Maximum time in milliseconds a connection can sit idle in the cache before being closed 60000 mysql_pool_connection_max_li...fetime_millis Maximum age in milliseconds of a pooled connection since it was first opened; when exceeded, the connection is closed inst...mysql_pool_size Maximum number of connections per MySQL catalog automatic (based on the CPU count) mysql_pool_wait_timeout_millis Timeout in milliseconds when waiting for a connection from the pool 30000 mysql_session_time_zone Session time zone to set... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- PostgreSQL Extension 7193
- The postgres extension allows DuckDB to directly read and write data from a running PostgreSQL database instance. The data can be queried directly from the underlying PostgreSQL database. Data can be loaded from PostgreSQL tables into DuckD
...greSQL to stdout false pg_enable_filter_pushdown Whether or not to use filter pushdown true pg_idle_in_transaction_timeout_millis PostgreSQL idle_in_transaction_session_timeout in milliseconds to set on scan connections NULL pg_null_byte_replacement Wh...ode used to read data, one of 'AUTO' , 'COPY_BINARY' , 'PLAIN_QUERY_BINARY' , 'PLAIN_QUERY_TEXT' AUTO pg_statement_timeout_millis PostgreSQL statement timeout in milliseconds to set on scan connections NULL pg_use_binary_copy Whether or not to use BINA... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work