Results of 1 - 9 of about 9 for lifetime (0.002 sec.)
- PostgreSQL Extension Connection Pool 12744
- 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
...") 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_th...read 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 taken from the pool...g pinned to the threads and are not made available to other threads, while still taking the place in the pool. pg_pool_max_lifetime_millis ( UBIGINT , default: 0 not enforced): maximum number of milliseconds the connection can be kept open. This number i... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- PostgreSQL Extension Functions 11504
- 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
...e getting 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 connec...thread ( BOOLEAN ): 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...: the number of times connections were not available in a thread-local cache and were taken from the main pool instead max_lifetime_millis ( UBIGINT ): maximum number of milliseconds a connection can be kept open idle_timeout_millis ( UBIGINT ): maximum... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- Connect 9239
- 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
...alization steps with a Connector , the client's thread-safety and connection-lifetime rules, and closing a database cleanly. Opening a Database sql.Open() takes the driver name duckdb and a data source name (...and shared across the pool. See the DuckDB concurrency documentation for how connections and threads interact. Connection Lifetime Temporary objects such as temporary tables are scoped to a connection. When code closes a connection, database/sql may ret... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
- Go Client 8879
- The latest stable release of the DuckDB Go client bundles DuckDB 2.0.0. Its own version tag encodes that DuckDB version; see Versioning below. The DuckDB Go client, duckdb-go , is a SQL driver that conforms to Go's built-in database/sql int
...query, open the database with sql.OpenDB() and a Connector . See Connect for connectors, configuration, and the connection lifetime. Build Tags Some client features are gated behind Go build tags , passed to go build with the -tags flag, for example go b.... Further Reading Connect — opening in-memory and file-backed databases, DSN configuration, connectors, and the connection lifetime. Run Queries — Exec , Query , prepared statements, parameter binding, transactions, and scanning results into Go values. I... - https://man.mtool.work/duckdb/2.0/clients/go/overview.html
- Troubleshoot 7998
- Overview This page collects common issues encountered when using the DuckDB Go client, together with their workarounds. Because the client uses cgo to embed DuckDB, most build problems are cgo or linker problems. If you run into a problem t
...r Reading Go Client — installation, build tags, and the bundled extensions. Connect — opening databases and the connection lifetime, whose failures are often build or linking problems. Run Queries — parameter binding, including the duckdb.Typed() hint an... - https://man.mtool.work/duckdb/2.0/clients/go/troubleshoot.html
- AWS Extension 7657
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...PROVIDER credential_chain, CHAIN 'sso', PROFILE '⟨my-sso-profile⟩' ); The token expires after the SSO session's configured lifetime. When it does, run aws sso login again. You do not need to recreate the secret. HTTP Proxy When credentials must be fetche... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- MySQL Extension 7657
- 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.
...is Maximum time in milliseconds a connection can sit idle in the cache before being closed 60000 mysql_pool_connection_max_lifetime_millis Maximum age in milliseconds of a pooled connection since it was first opened; when exceeded, the connection is clos... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Metrics 7657
- DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr
...lumns , optimizer.statistics_propagation , optimizer.common_subexpressions , optimizer.common_aggregate , optimizer.column_lifetime , optimizer.build_side_probe_side , optimizer.limit_pushdown , optimizer.top_n , optimizer.compressed_materialization , op... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- Release Cycle 7477
- This document outlines the DuckDB and core extension release cycle framework. It is intended for developers working on DuckDB extensions to better understand the underlying processes. Overview DuckDB follows Semantic Versioning ( v<MAJOR>.<
....<y+1>-codename LTS release : Long term support release. These releases will receive support (patch releases) beyond their lifetime in the active release cycle. Currently LTS releases will receive 1 year of support Unstable API extension : An extension t... - https://man.mtool.work/duckdb/2.0/dev/release_cycle.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work