Results of 1 - 10 of about 58 for running (0.003 sec.)
- Benchmark Suite – DuckDB 13012
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...NS = 'tpch' make Listing Benchmarks To list all available benchmarks, run: build/release/benchmark/benchmark_runner --list Running Benchmarks Running a Single Benchmark To run a single benchmark, issue the following command: build/release/benchmark/benc...addition.benchmark --out = timings.out The output will contain the following: 0.182472 0.185027 0.184163 0.185281 0.182948 Running Multiple Benchmark Using a Regular Expression You can also use a regular expression to specify which benchmarks to run. Be...hell, hence this requires proper quoting or escaping). build/release/benchmark/benchmark_runner "benchmark/micro/nulls/.*" Running All Benchmarks Not specifying any argument will run all benchmarks. build/release/benchmark/benchmark_runner Other Options... - https://man.mtool.work/duckdb/1.3/dev/benchmark.html
- Securing DuckDB – DuckDB 10846
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...an be set to show all information contained within a security key. It is recommended not to turn on this option if you are running untrusted SQL input. Queries can access the secrets defined in the Secrets Manager. For example, if there is a secret defi...stored in unencrypted binary format on the disk. These have the same permissions as SSH keys, 600 , i.e., only user who is running the DuckDB (parent) process can read and write them. Locking Configurations Security-related configuration settings genera...to do so will result in an error: Invalid Input Error: Cannot upgrade allow_community_extensions setting while database is running This prevents untrusted SQL input from re-enabling settings that were explicitly disabled for security reasons. Neverthele... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/overview.htm...
- Tuning Workloads – DuckDB 10553
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...erforming as well as expected, it's worth studying their query plans: Use EXPLAIN to print the physical query plan without running the query. Use EXPLAIN ANALYZE to run and profile the query. This will show the CPU time that each step in the query takes...to billions of tuples should be avoided at all costs. Prepared Statements Prepared statements can improve performance when running the same query many times, but with different parameters. When a statement is prepared, it completes several of the initia...r output. When it is executed, those steps can be skipped, improving performance. This is beneficial mostly for repeatedly running small queries (with a runtime of < 100ms) with different sets of parameters. Note that it is not a primary design goal for... - https://man.mtool.work/duckdb/1.3/guides/performance/how_to_tune_workloads.html
- DuckDB Environment – DuckDB 10421
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s Copy Markdown DuckDB Environment DuckDB provides a number of functions and PRAGMA options to retrieve information on the running DuckDB instance and its environment. Version The version() function returns the version number of DuckDB. SELECT version (...form is used when installing extensions . To retrieve the platform, use the following PRAGMA : PRAGMA platform ; On macOS, running on Apple Silicon architecture, the result is: platform osx_arm64 On Windows, running on an AMD64 architecture, the platfor...m is windows_amd64 . On Ubuntu Linux, running on the ARM64 architecture, the platform is linux_arm64 . Extensions To get a list of DuckDB extension and their status (e.... - https://man.mtool.work/duckdb/1.3/guides/meta/duckdb_environment.html
- TPC-H Extension – DuckDB 9689
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...bgen ( sf = 1 ); Calling dbgen does not clean up existing TPC-H tables. To clean up existing tables, use DROP TABLE before running dbgen : DROP TABLE IF EXISTS customer ; DROP TABLE IF EXISTS lineitem ; DROP TABLE IF EXISTS nation ; DROP TABLE IF EXISTS...DROP TABLE IF EXISTS part ; DROP TABLE IF EXISTS partsupp ; DROP TABLE IF EXISTS region ; DROP TABLE IF EXISTS supplier ; Running a Query To run a query, e.g., query 4, use: PRAGMA tpch ( 4 ); o_orderpriority order_count 1-URGENT 10594 2-HIGH 10476 3-M...tes 211 GB 1,000 265 GB 2 h 53 minutes 647 GB 3,000 796 GB 8 h 30 minutes 1799 GB The numbers shown above were achieved by running the dbgen function in a single step, for example: CALL dbgen ( sf = 300 ); If you have a limited amount of memory availabl... - https://man.mtool.work/duckdb/1.3/core_extensions/tpch.html
- Environment – DuckDB 9689
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...n network-attached storage (NAS). These setups include NFS , network drives such as SMB and Samba . Based on user reports, running read-write workloads on network-attached storage can result in slow and unpredictable performance, as well as spurious err...ors cased by the underlying file system. Warning Avoid running DuckDB in read-write mode on network-attached storage. Bestpractice Fast disks are important if your workload is larger th...sive workloads. Therefore, it's recommended to use a Linux distribution with glibc for performance-oriented workloads when running DuckDB. Memory Allocator If you have a many-core CPU running on a system where DuckDB ships with jemalloc as the default m... - https://man.mtool.work/duckdb/1.3/guides/performance/environment.html
- Debugging – DuckDB 8972
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...and line parameter (e.g., build/debug/test/unittest test/sql/projection/test_simple_projection.test ). For more options on running a subset of the tests see the Triggering which tests to run section. After that, a debugger can be attached to the program...an optional mode unskip . Any queries between the two statements will not be executed. Triggering Which Tests to Run When running the unittest program, by default all the fast tests are run. A specific test can be run by adding the name of the test as...in the “projection” directory: build/debug/test/unittest "[projection]" All tests, including the slow tests, can be run by running the tests with an asterisk. To run all tests, including the slow tests: build/debug/test/unittest "*" We can run a subset... - https://man.mtool.work/duckdb/1.3/dev/sqllogictest/debugging.html
- Securing Extensions – DuckDB 8972
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...DB Copy Markdown Securing Extensions DuckDB has a powerful extension mechanism, which have the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration op...low_community_extensions = true ; Invalid Input Error: Cannot upgrade allow_community_extensions setting while database is running Community Extensions DuckDB has a Community Extensions repository , which allows convenient installation of third-party ex...malicious developer could create and register a harmless-looking DuckDB extension that steals your crypto coins. If you're running a web service that executes untrusted SQL from users with DuckDB, we recommend disabling community extensions. To do so, r... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/securing_ext...
- UI Extension – DuckDB 8826
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Wasm, v1.2.1 or later. Usage To start the UI from the command line: duckdb -ui To start the UI from SQL: CALL start_ui (); Running either of these will open the UI in your default browser. The UI connects to the DuckDB instance it was started from, so a...with a CSV available as a view using the -cmd argument : duckdb -cmd "CREATE VIEW view_name AS FROM ' filename .csv';" -ui Running the UI in Read-Only Mode The DuckDB UI uses DuckDB tables as storage internally (e.g., for saving notebooks). Therefore, r...sage Local Query Execution Configuration Local Port Remote URL Polling Interval Tips Opening a CSV File with the DuckDB UI Running the UI in Read-Only Mode Limitations... - https://man.mtool.work/duckdb/1.3/core_extensions/ui.html
- CLI Client – DuckDB 8679
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s a tldr page , which summarizes the most common uses of the CLI client. If you have tldr installed, you can display it by running tldr duckdb . Getting Started Once the CLI executable has been downloaded, unzip it and save it to any directory. Navigate...e. D To open or create a persistent database , simply include a path as a command line argument: duckdb my_database.duckdb Running SQL Statements in the CLI Once the CLI has been opened, enter a SQL statement followed by a semicolon, then hit enter and...d. The .read command requires only one argument: the path to the file containing the SQL and/or commands to execute. After running the commands in the file, control will revert back to the terminal. Output from the execution of that file is governed by... - https://man.mtool.work/duckdb/1.3/clients/cli/overview.html
DuckDB 1.3 Documentation / man.mtool.work