Results of 1 - 8 of about 8 for idle (0.002 sec.)
- PostgreSQL Extension Connection Pool 13266
- 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
...these points the extensions uses an in-memory connection pool. With it a limited number of connections are kept open (and idle) after use and can be reused for subsequent queries. Parallel Scans Due to DuckDB's multithreaded query processing, postgr...be opened, not a full backend process. Thus in deployment 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 t...per Thread The postgres extension supports running a background thread (so called "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. Separat... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- PostgreSQL Extension Functions 10591
- 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
...on pool reaper 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 che...whether to enable the connection pool reaper thread, that periodically scans the pool to check the max_lifetime_millis and idle_timeout_millis and closes the connection which exceed the specified values. Either max_lifetime_millis or idle_timeout_mil..., 'wait' (block until available), 'try' (fail immediately if unavailable) available_connections ( UBIGINT ): the number of idle connection that are currently available in the pool max_connections ( UBIGINT ): maximum number of connections that are al... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Connect 8404
- Overview The Go client works through the standard database/sql types: a *sql.DB is a pool of connections to a DuckDB database. This page covers opening in-memory and file-backed databases, passing DuckDB configuration options, running initi
...s temporary tables are scoped to a connection. When code closes a connection, database/sql may return it to the pool as an idle connection rather than actually closing it, so a temporary table can outlive the code that created it. To make closing a c...onnection tear it down, disable idle connections: db.SetMaxIdleConns(0) Closing a Database DuckDB runs in the same process as the Go application, so all of its... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
- MySQL Extension 8115
- 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.
...ol limit), wait (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_co... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Reference 8115
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...tions the server accepts. Beyond this, new connections are refused. quack_server_keep_alive_timeout UBIGINT 300 Seconds an idle keep-alive connection is kept open by the server. Client Identity and Reconnects Setting Type Default Description quack_de...knowledge results and the server caches the last result until it is acknowledged. quack_result_ttl UBIGINT 3600 Seconds an idle cached result is kept before it is dropped ( 0 = never). quack_cache_max_rows UBIGINT 100000 Maximum number of rows the se... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- PostgreSQL Extension 8043
- 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
...int all queries sent to PostgreSQL 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 NU... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- PostgreSQL Extension and the Secret Manager 7826
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...H CHANNEL_BINDING CONNECT_TIMEOUT CLIENT_ENCODING OPTIONS APPLICATION_NAME FALLBACK_APPLICATION_NAME KEEPALIVES KEEPALIVES_IDLE KEEPALIVES_INTERVAL KEEPALIVES_COUNT TCP_USER_TIMEOUT REPLICATION GSSENCMODE SSLMODE REQUIRESSL SSLNEGOTIATION SSLCOMPRESS... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- I/O 7826
- Warning DuckDB ships with safe defaults. The configuration options described on this page are advanced options, so proceed with caution when changing them. Asynchronous I/O New Asynchronous I/O was introduced in DuckDB 2.0. Starting with v2
...g and defaults to the number of CPU cores. Regular threads prioritize query processing but can also perform I/O tasks when idle. The asynchronous pool contains threads dedicated to blocking I/O. As these threads spend most of their time waiting for r... - https://man.mtool.work/duckdb/2.0/data/io.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work