Results of 1 - 10 of about 12 for blocks (0.002 sec.)
- Pragmas 12116
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...ned results are given below: database_name VARCHAR, -- database name database_size VARCHAR, -- total block count times the block size block_size BIGINT, -- database block size total_blocks BIGINT, -- total blocks in the database used_blocks BIGINT, --...used blocks in the database free_blocks BIGINT, -- free blocks in the database wal_size VARCHAR, -- write ahead log size memory_usage...AGMA user_agent; Metadata Information The following statement returns information on the metadata store ( block_id , total_blocks , free_blocks , and free_list ): PRAGMA metadata_info; Extension Versions The following statement returns the name, versio... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Azure Extension 11479
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...dows.net/⟨my_container⟩/⟨path⟩/output.parquet'; Since v1.5.4, the extension buffers written data locally and uploads it in blocks of azure_write_block_size bytes (default: 8 MiB). By default, the uploaded blocks are committed when the file is closed, s...o other readers see the new content only after the write completes. To commit earlier, set azure_write_staged_blocks_per_commit to the number of blocks after which an intermediate commit happens. Warning An intermediate commit makes an inc...e default 0 for Parquet files and for Delta, Iceberg or DuckLake tables. Writing Large Files Azure limits a blob to 50,000 blocks. With the default block size of 8 MiB, the largest file you can write is about 390 GiB. To write larger files, increase az... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- DROP Statement 11161
- The DROP statement removes a catalog entry added previously with the CREATE command. Examples Delete the table with the name tbl : DROP TABLE tbl; Drop the view with the name view1 ; do not throw an error if the view does not exist: DROP VI
...TABLE should free the memory used by the table, but not always disk space. Even if disk space does not decrease, the free blocks will be marked as free . For example, if we have a 2 GB file and we drop a 1 GB table, the file might still be 2 GB, but i...t should have 1 GB of free blocks in it. To check this, use the following PRAGMA and check the number of free_blocks in the output: PRAGMA database_size; Fo... - https://man.mtool.work/duckdb/2.0/sql/statements/drop.html
- Configuration 9409
- 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
...xtension repositories are 'allowed', 'forbidden' (which also distrusts existing repositories) or 'undecided' (the default: blocks adding new repositories, but keeps trusting existing ones). While the database is running the setting can only move from '...an be set by callers/wrappers to tag their own traffic when DuckDB makes a request. VARCHAR default_block_size The default block size for new duckdb database files. New means that the file is being created and does not yet exist. UBIGINT 262144 default...block_size Maximum size in bytes of an external file cache block for local (non-remote) files. Larger reads are split into blocks of this size, which are fetched in parallel. UBIGINT 16384 external_file_cache_remote_max_block_size Maximum size in bytes... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Building Extensions 9091
- Extensions can be built from source and installed from the resulting local binary. Building Extensions To build using extension flags, set the BUILD_EXTENSIONS flag to the list of extensions that you want to be built. For example: BUILD_EXT
...remove these checks, this is mostly done to check that the performance hit of these checks is negligible. DESTROY_UNPINNED_BLOCKS When previously pinned blocks in the BufferManager are unpinned, with this flag enabled we destroy them instantly to make... - https://man.mtool.work/duckdb/2.0/dev/building/building_extensions.html
- Building Configuration 8773
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...bug This build runs with all the debug information, including symbols, assertions and #ifdef DEBUG blocks. Due to these, binaries of this build are expected to be slow. Note: the special debug defines are not automatically set f...or this build. relassert This build does not trigger the #ifdef DEBUG code blocks but it still has debug symbols that make it possible to step through the execution with line number information and D_ASSE... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- HTTP(S) Support 7658
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...ormat is block-based and stores per-column and per-row-group statistics, DuckDB uses HTTP range requests to fetch only the blocks required by a query when a remote database file is attached read-only: ATTACH 'https://domain.tld/file.duckdb' AS db (READ... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- Securing Extensions 7499
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...tension repositories are 'allowed' , 'forbidden' (which also distrusts existing repositories) or 'undecided' (the default: blocks adding new repositories, but keeps trusting existing ones). While the database is running, the setting can only move from... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- What's New in the Docs for 2.0 7499
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...r variable syntax. Explicit join type syntax, including nearest ( NEAREST ) joins Data-modifying CTEs , including COPY ... blocks in CTEs Nested schemas The $⟨variable⟩ variable shorthand , including session variables as default parameter values JSON m... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Create Synthetic Data 7340
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
DuckDB 2.0 Documentation / man.mtool.work