Results of 1 - 9 of about 9 for timeout (0.002 sec.)
- PostgreSQL Extension Connection Pool 12402
- 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
...ened, 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 to disabl...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. Separate thread is run for each connections pool, it can be enabled/disabled using p...g_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... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- Reference 10910
- 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
...ote uri , stream result back. Accepts the named parameters token , disable_ssl , ssl_fingerprint , client_id and heartbeat_timeout , which behave like the ATTACH options of the same name. Pass token to override any matching quack secret on the client si...tificate. CLIENT_ID VARCHAR quack_default_client_id Client identifier sent to the server (minimum 4 characters). HEARTBEAT_TIMEOUT UBIGINT quack_default_heartbeat_timeout Heartbeat lease timeout in seconds requested from the server. Settings All setting...mum number of concurrent connections 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... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- PostgreSQL Extension Functions 10677
- 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
...nection 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 con...ol 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 checked whe...er 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_millis must... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- PostgreSQL Extension 8951
- 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
...ameters can be found in the PostgreSQL documentation . dbname=postgresscanner host=localhost port=5432 dbname=mydb connect_timeout=10 Name Description Default dbname Database name [user] host Name of host to connect to localhost hostaddr Host IP address...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 NULL pg_null_byte_replace...Query mode 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 u... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/overview.html
- MySQL Extension 8034
- 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.
...mit), 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_connection...e false 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... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Securing Quack with a Reverse Proxy 7801
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
...mid-INSERT. client_max_body_size 256M; # Long-running queries can sit on the wire between FETCHes for # minutes. Raise the timeouts above nginx's default 60s. proxy_read_timeout 600s; proxy_send_timeout 600s; location / { proxy_pass http://127.0.0.1:949... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- PostgreSQL Extension and the Secret Manager 7567
- 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
...onding connection options of libpq : HOST HOSTADDR PORT DBNAME USER PASSWORD PASSFILE REQUIRE_AUTH CHANNEL_BINDING CONNECT_TIMEOUT CLIENT_ENCODING OPTIONS APPLICATION_NAME FALLBACK_APPLICATION_NAME KEEPALIVES KEEPALIVES_IDLE KEEPALIVES_INTERVAL KEEPALIV...ES_COUNT TCP_USER_TIMEOUT REPLICATION GSSENCMODE SSLMODE REQUIRESSL SSLNEGOTIATION SSLCOMPRESSION SSLCERT SSLKEY SSLKEYLOGFILE SSLPASSWORD SSLCERTMO... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- SQLite Extension 7567
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...ch Options The following options can be passed to ATTACH when attaching a SQLite database: Option Description Default BUSY_TIMEOUT Time in milliseconds to wait when the SQLite file is locked by another process before returning a database is locked error...iately. 5000 JOURNAL_MODE SQLite journaling mode , e.g., 'WAL' . (SQLite default) ATTACH 'file.db' AS f (TYPE sqlite, BUSY_TIMEOUT 0); ATTACH 'file.db' AS f (TYPE sqlite, JOURNAL_MODE 'WAL'); Settings The extension exposes the following configuration pa... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- Configuration 6884
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...off factor for exponentially increasing retry wait time FLOAT 4.0 http_retry_wait_ms Time between retries UBIGINT 100 http_timeout HTTP timeout read/write/connection/retry (in seconds) UBIGINT 30 httpfs_client_implementation Select which HTTP client imp... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work