Results of 1 - 10 of about 11 for environments (0.001 sec.)
- My Workload Is Slow 13300
- If you find that your workload in DuckDB is slow, we recommend performing the following checks. More detailed instructions are linked for each point. Do you have enough memory? DuckDB works best if you have 1-4 GB memory per thread . Is you
...'...'; . While this sounds counter-intuitive, it can sometimes improve query performance, especially in memory-constrained environments where other processes are likely using more than 20% of the total system memory. Are you using a fast disk? Network-attach...ud block storage) cause write-intensive and larger than memory workloads to slow down. For running such workloads in cloud environments, it is recommended to use instance-attached storage (NVMe SSDs). Are you using indexes or constraints (primary key, unique... - https://man.mtool.work/duckdb/2.0/guides/performance/my_workload_is_slow.html
- DuckDB Docker Container 10651
- DuckDB has an official Docker image , which supports both the ARM64 (AArch64) and x86_64 (AMD64) architectures. Usage To use the DuckDB Docker image, run: docker run --rm -it -v "$(pwd):/workspace" -w /workspace duckdb/duckdb Using the Duck
...er, enable host networking. This setting forwards all ports from the container, so exercise caution and avoid it in secure environments. docker run --rm -it -v "$(pwd):/workspace" -w /workspace --net host duckdb/duckdb Then, launch the UI as follows: CALL st... - https://man.mtool.work/duckdb/2.0/operations_manual/duckdb_docker.html
- Safe Mode 10064
- The DuckDB CLI client supports “safe mode”. Safe mode can be enabled from the command line using the -safe argument : duckdb -safe Alternatively, it can be activated during a session using the .safe_mode dot command . In safe mode, the CLI
...de is activated, it cannot be deactivated in the same DuckDB CLI session. For more information on running DuckDB in secure environments, see the “Securing DuckDB” page .... - https://man.mtool.work/duckdb/2.0/clients/cli/safe_mode.html
- Securing DuckDB 9175
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...itive data or in shared environments. This page documents DuckDB's security model and security-related settings. The right configuration depends on your use ca...ons run with the same privileges as the DuckDB process itself, so they warrant careful consideration in security-sensitive environments. Autoloading DuckDB can automatically load core extensions when certain SQL statements require them. To maintain full cont... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- Command Line Client 8890
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...or not writable, startup can fail with an error such as IO Error: Failed to create directory . In sandboxed or restricted environments, set the HOME environment variable to a writable location to control where these files are created. See Files Created by D...k head and run a SQL statement. Note that the duck head is built with Unicode characters and does not work in all terminal environments (e.g., in Windows, unless running with WSL and using the Windows Terminal). .prompt "{color:yellow1}{sql:select current_da... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
- Deploy 8001
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...er details, see below. JS Worker Component. Compiled to JavaScript code, possibly instantiated multiple times for threaded environments. For further details, see below. Wasm Worker Component. Compiled as a WebAssembly file and instantiated by the browser. Fo... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- PostgreSQL Extension Connection Pool 8001
- 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
...opening a new connections only causes a new networking socket to 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 confi... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- Installing Extensions 8001
- To install core DuckDB extensions, use the INSTALL command. For example: INSTALL httpfs; This installs the extension from the default repository ( core ). Extension Repositories By default, DuckDB extensions are installed from a single repo
...installed into the first directory and loaded from any of them, which is useful, e.g., for package managers or air-gapped environments: SET extension_directories = ['/path/to/your/extension/directory']; SET extension_directories = ['/usr/lib/duckdb/extensio... - https://man.mtool.work/duckdb/2.0/extensions/installing_extensions.html
- Vector Similarity Search Extension 7415
- The vss extension is an experimental extension for DuckDB that adds indexing support to accelerate vector similarity search queries using DuckDB's new fixed-size ARRAY type. See the announcement blog post and the “What's New in the Vector S
...DuckDB's recovery process to proceed without issues. But we still recommend that you do not use this feature in production environments. With the hnsw_enable_experimental_persistence option enabled, the index will be persisted into the DuckDB database file (... - https://man.mtool.work/duckdb/2.0/core_extensions/vss.html
- ADBC Client 7112
- Installation To use the DuckDB ADBC client, download the libduckdb archive for your platform and follow the instructions below . For Python, install the duckdb package instead, as described in the Python section . The latest stable version
...e necessary options, we can proceed to initialize our database. Below is how you can do so with various different language environments. C++ We begin our C++ example by declaring the essential variables for querying data through ADBC. These variables include... - https://man.mtool.work/duckdb/2.0/clients/adbc.html
DuckDB 2.0 Documentation / man.mtool.work