Results of 1 - 10 of about 12 for wait (0.002 sec.)
- PostgreSQL Extension Functions 14079
- 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
...de ( VARCHAR , default: 'force' ): how to acquire connections from the pool: 'force' (always connect, ignore pool limit), 'wait' (block until available), 'try' (fail immediately if unavailable) max_connections ( UBIGINT ): maximum number of connectio...a connection 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 avail...database acquire_mode ( VARCHAR ): how to acquire connections from the pool: 'force' (always connect, ignore pool limit), 'wait' (block until available), 'try' (fail immediately if unavailable) available_connections ( UBIGINT ): the number of idle co... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- PostgreSQL Extension Connection Pool 10011
- 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
...de ( VARCHAR , default: 'force' ): how to acquire connections from the pool: 'force' (always connect, ignore pool limit), 'wait' (block until available), 'try' (fail immediately if unavailable) pg_pool_max_connections ( UBIGINT , default: 4 <= cpu_co...tion pool for each attached Postgres database. This number can be temporary exceeded when parallel scans are used. pg_pool_wait_timeout_millis ( UBIGINT , default: 30000 ): maximum number of milliseconds to wait when acquiring a connection from a poo... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- Quack on WebAssembly 9852
- CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th
...ck-name my-quack-demo \ --template-url https://duckdb-quack-ami.s3.us-east-1.amazonaws.com/quack.yaml \ --region us-east-2 Wait approx. 2 minutes for the deployment to complete (this command is blocking): aws cloudformation wait stack-create-complete... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
- Appender 8667
- Use an appender to insert rows that your Python code produces. It collects rows and writes them together in one SQL statement; this is called flushing. The with block below flushes on successful exit: import duckdb con = duckdb.connect() co
...another call is running on the connection keeps its buffered rows, and so does an interrupted flush. Finish the result or wait for the other call, then call flush() again. Other failures discard the rows and raise an exception. An interrupted flush...running during a flush, DuckDB treats it as an error in that function and discards the buffered rows. Memory Use The rows waiting to be flushed count toward DuckDB's memory_limit . When they no longer fit in memory, DuckDB can store them in temporar...tion until you call clear() . Connections and Threads Concurrent calls on the same appender raise an exception rather than wait. Calls from a callback during a flush also raise an exception. Use a separate appender for each thread. You can append row... - https://man.mtool.work/duckdb/2.0/clients/python/appender.html
- CHECKPOINT Statement 8490
- The CHECKPOINT statement synchronizes data in the write-ahead log (WAL) to the database data file. Examples Synchronize data in the default database: CHECKPOINT; Synchronize data in the specified database: CHECKPOINT file_db; Synchronize da
...arting: FORCE CHECKPOINT; In earlier DuckDB versions, FORCE CHECKPOINT aborted any in-progress transactions. From v1.4, it waits until it can grab the checkpoint lock. Checkpointing In-Memory Tables Starting with v1.4.0, in-memory tables support chec...int actions. Behavior The default CHECKPOINT command will fail if there are any running transactions. Including FORCE will wait until it can grab the checkpoint lock and then execute the checkpoint operation. In DuckDB versions before v1.4, FORCE CHE... - https://man.mtool.work/duckdb/2.0/sql/statements/checkpoint.html
- MySQL Extension 8330
- 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.
...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 available), or try (fail immediately if none is available) force mysql_pool_connection_idle_timeout_mi...reuse 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 t... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Deploying Quack 8154
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
...er-instance token and connection URI. One-Click Launch Open the Launch Stack URL . Click Create stack in the bottom right. Wait about two minutes for CREATE_COMPLETE . Open the stack's Outputs tab. Click the ConnectURL value to open a shell.duckdb.or...e Let's Encrypt TLS. An AWS::EC2::SecurityGroup opening ports 80 (ACME challenge) and 443 (HTTPS). An AWS::CloudFormation::WaitCondition the instance signals once the RPC server is ready. CFN Outputs carrying the ready URI, per-instance token, and tw... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- Multiple Python Threads 7994
- This page demonstrates how to simultaneously insert into and read from a DuckDB database across multiple Python threads. This could be useful in scenarios where new data is flowing in and an analysis should be periodically re-run. Note that
...s one call at a time: a call from a second thread while another call is running raises a ResourceInUseException instead of waiting. def write_from_thread(duckdb_con): # Create a DuckDB connection specifically for this thread local_con = duckdb_con.cu...sults when testing random.shuffle(threads) Run Threads and Show Results Now, kick off all threads to run in parallel, then wait for all of them to finish before printing out the results. Note that the timestamps of readers and writers are intersperse... - https://man.mtool.work/duckdb/2.0/guides/python/multiple_threads.html
- Configuration 7658
- 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
...CHAR http_retries HTTP retries on I/O error UBIGINT 3 http_retry_backoff Backoff 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 (... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- SQLite Extension 7658
- 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
...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. Set to 0 to fail immediatel... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
DuckDB 2.0 Documentation / man.mtool.work