Performance Tuning

Beacon Query Engine Settings

This chapter focuses on practical performance knobs that are safe to tune in production.

Beacon is built on DataFusion. Most performance tuning comes down to:

• How much parallelism Beacon is allowed to use (threads)
• How much memory is available to the query engine before spilling to disk
• Whether Beacon can avoid unnecessary IO (projection pushdown, caches)

TIP

All settings below are environment variables. See the full list in configuration.md.

CPU and concurrency

BEACON_WORKER_THREADS

Beacon uses this value to size its Tokio runtime (the executor that runs API requests and query work).

• If you run Beacon on a dedicated machine, start with BEACON_WORKER_THREADS ~= number of physical cores.
• If the same host also runs other heavy services, cap this to leave headroom.

For IO-heavy workloads (remote object storage, NetCDF reads over HTTP), more threads can help. For CPU-heavy workloads (aggregations, joins), scaling is limited by CPU.

Memory and disk spilling

BEACON_VM_MEMORY_SIZE

This controls the DataFusion memory pool size (in MB). When queries exceed this pool, DataFusion can spill to disk.

• Larger values generally improve performance by reducing spill frequency.
• If you see high disk activity and slow queries under load, increase this first.

WARNING

Spilling uses the OS temp area (DataFusion disk manager). For best performance, ensure your temp directory is on fast storage and has enough free space.

Avoiding unnecessary reads

BEACON_ENABLE_PUSHDOWN_PROJECTION

When enabled, Beacon will attempt to project only the columns referenced by your JSON query select list when building the scan.

• Enabled by default (true), so queries on “wide” datasets only decode the columns they select.
• Set to false only to work around a suspected projection bug or to force the simplest scan behavior.

Query language and parsing

BEACON_ENABLE_SQL

SQL parsing/execution is guarded by this flag.

• Set to true to allow SQL queries.
• Keep false if you only use the JSON query API and want to reduce exposed surface area.

Geospatial function cache

BEACON_ST_WITHIN_POINT_CACHE_SIZE

Controls the cache capacity used by the ST_WithinPoint implementation.

• Increase this if you run many repeated point-in-polygon style queries over similar geometries.
• Reduce it if memory pressure is an issue and you don’t benefit from reuse.

Filesystem and object-store listing

BEACON_ENABLE_FS_EVENTS

When using local filesystem datasets, enabling filesystem events allows Beacon’s object-store layer to maintain an in-memory view of changes and avoid expensive directory rescans.

• Enable (true) when datasets change frequently and you care about fast “list/search datasets” operations.
• Keep disabled if you are on a platform where file watching is noisy/unsupported.

BEACON_S3_DATA_LAKE, BEACON_ENABLE_S3_EVENTS, BEACON_S3_BUCKET, BEACON_S3_ENABLE_VIRTUAL_HOSTING

These control whether Beacon uses S3-compatible object storage for datasets and how it addresses buckets.

• For performance, prefer placing Beacon close (network-wise) to the object store.
• If you see high latency when listing, consider enabling event-driven updates (BEACON_ENABLE_S3_EVENTS) if your S3 backend supports it.

NetCDF Tuning

NetCDF performance in Beacon is mainly affected by:

• How often Beacon needs to open the file and infer schema
• Whether opened readers are cached

TIP

For extremely large .nc files, performance may improve by splitting them into smaller files or converting to chunk-friendly formats (e.g. Zarr), depending on your access pattern. Scans are emitted in batches of BEACON_BATCH_SIZE rows (default 64000).

Reader cache (avoid reopening files)

BEACON_NETCDF_USE_READER_CACHE and BEACON_NETCDF_READER_CACHE_SIZE

With reader caching enabled, Beacon reuses opened NetCDF readers (also keyed by path + last-modified time). This helps when the same files are accessed repeatedly across queries.

Recommendations:

• Keep BEACON_NETCDF_USE_READER_CACHE=true (default) for repeated-access workloads.
• Increase BEACON_NETCDF_READER_CACHE_SIZE if your “hot set” of NetCDF files is larger than the default (128).
• Disable reader caching if you have extremely high file churn and want to minimize open file handles.

Suggested starting points

For a “many NetCDF files” deployment:

• BEACON_NETCDF_USE_READER_CACHE=true
• BEACON_NETCDF_READER_CACHE_SIZE=16384 (size the cache to your hot set of files)

Per-file statistics used for query pruning are controlled separately by BEACON_NETCDF_ENABLE_STATISTICS (default true); keep it on unless you are debugging pruning behavior.

Zarr predicate pushdown

Beacon’s Zarr reader applies predicate pushdown automatically through the shared N-dimensional engine. Based on your query’s filters, Beacon:

• Prunes Zarr chunks that cannot satisfy the predicate, so only the relevant chunks are read.
• Slices 1D “coordinate-like” arrays (for example time, latitude, longitude) to the requested ranges.

There is nothing to configure — no statistics_columns to declare and no statistics to pre-compute. Just read the store and filter; the engine handles the rest.

SQL

POST /api/query
Content-Type: application/json

{
	"sql": "SELECT * FROM read_zarr(['datasets/**/*.zarr/zarr.json']) WHERE valid_time >= '2025-01-01' AND longitude < 30 LIMIT 100",
	"output": { "format": "csv" }
}

JSON

POST /api/query
Content-Type: application/json

{
	"from": {
		"zarr": {
			"paths": ["datasets/**/*.zarr/zarr.json"]
		}
	},
	"select": ["valid_time", "latitude", "longitude"],
	"filters": [
        { "column": "valid_time", "min": "2025-01-01" },
        { "column": "longitude", "min": 15, "max": 30 }
    ],
	"limit": 100,
	"output": { "format": "csv" }
}

TIP

For collections that are queried repeatedly, re-encode the Zarr stores into a single Atlas collection. Atlas adds per-dataset statistics pruning on top of chunk pruning, dropping whole datasets before any chunk is read.

Atlas Tuning

Atlas stores are opened through a atlas.json registry. To avoid re-opening the same store on every query, Beacon keeps a cache of opened Atlas readers.

Reader cache (avoid reopening stores)

BEACON_ATLAS_USE_READER_CACHE and BEACON_ATLAS_READER_CACHE_SIZE

With reader caching enabled, Beacon reuses opened Atlas readers across queries instead of re-parsing the atlas.json registry each time.

Recommendations:

• Keep BEACON_ATLAS_USE_READER_CACHE=true (default) when the same Atlas collections are queried repeatedly.
• Increase BEACON_ATLAS_READER_CACHE_SIZE (default 32) if you query more distinct Atlas stores than the cache can hold at once.