# Community **URL:** https://community.questdb.com/c/community/4.md?page=1 [Latest](https://community.questdb.com/latest.md) · [Categories](https://community.questdb.com/categories.md) · [Tags](https://community.questdb.com/tags.md) **Page:** 2 --- ## [Lots of small inserts cause a growing WAL. How to handle this?](https://community.questdb.com/t/lots-of-small-inserts-cause-a-growing-wal-how-to-handle-this/960)
**Author:** [@YBrink](https://community.questdb.com/u/YBrink)\ **Replies:** 8\ **Last updated:** [February 19, 2026, 4:37pm UTC](https://community.questdb.com/t/lots-of-small-inserts-cause-a-growing-wal-how-to-handle-this/960 "2026-02-19T16:37:03Z")
Old situation Originally, we were operating on a relational database, with our data grouped by value type\*\*.\*\* All data points from all sources of matching value types were mixed together inside these type‑based tables. … --- ## [Metadata read timeout](https://community.questdb.com/t/metadata-read-timeout/957)
**Author:** [@suny960](https://community.questdb.com/u/suny960)\ **Replies:** 1\ **Last updated:** [February 17, 2026, 10:56am UTC](https://community.questdb.com/t/metadata-read-timeout/957 "2026-02-17T10:56:19Z")
9.2.3,cairo.spin.lock.timeout=30s,cairo.spin.lock.timeout has been set to 30s --- ## [bitemporal data and questdb performance](https://community.questdb.com/t/bitemporal-data-and-questdb-performance/956)
**Author:** [@nick](https://community.questdb.com/u/nick)\ **Replies:** 1\ **Last updated:** [February 17, 2026, 10:55am UTC](https://community.questdb.com/t/bitemporal-data-and-questdb-performance/956 "2026-02-17T10:55:57Z")
If I want to support bitemporal data with rare corrections, is the right thing to do to have a table designed like this: CREATE TABLE events ( event\_id SYMBOL, event\_time TIMESTAMP, -- designated timestamp … --- ## [Documentation for Earlier QuestDB Versions](https://community.questdb.com/t/documentation-for-earlier-questdb-versions/953)
**Author:** [@AG1](https://community.questdb.com/u/AG1)\ **Replies:** 3\ **Last updated:** [February 10, 2026, 3:02pm UTC](https://community.questdb.com/t/documentation-for-earlier-questdb-versions/953 "2026-02-10T15:02:22Z")
Hello, we have an older version of QuestDB running. We have not migrated to a new version yet but with that said, is there any way to access the QuestDB logs for the other versions of QuestDB? The “Docs” page from Quest… --- ## [QuestDB 9.3.2 Release](https://community.questdb.com/t/questdb-9-3-2-release/954)
**Author:** [@javier](https://community.questdb.com/u/javier)\ **Replies:** 0\ **Last updated:** [February 9, 2026, 9:16am UTC](https://community.questdb.com/t/questdb-9-3-2-release/954 "2026-02-09T09:16:13Z")
QuestDB 9.3.2 is here - and TICK is the headline. It is a new temporal interval syntax that turns complex time-range filters into one-liners. If you have ever wrestled with timezone-aware schedules, business day logic, o… --- ## [Alter to parquet --\> abort](https://community.questdb.com/t/alter-to-parquet-abort/942)
**Author:** [@Gabriel](https://community.questdb.com/u/Gabriel)\ **Replies:** 3\ **Last updated:** [January 19, 2026, 10:34am UTC](https://community.questdb.com/t/alter-to-parquet-abort/942 "2026-01-19T10:34:08Z")
Hello, I was trying to alter many 135 partitions to PARQUET on QDB 9.3.0 / Windows 11. At some point, it keeps crashing. In the logs I see: 2026-01-12T10:37:47.109109Z I i.q.c.TableWriter switched partition \[path=\\nim… --- ## [QuestDB 9.3.0 Release](https://community.questdb.com/t/questdb-9-3-0-release/944)
**Author:** [@javier](https://community.questdb.com/u/javier)\ **Replies:** 0\ **Last updated:** [January 16, 2026, 4:24pm UTC](https://community.questdb.com/t/questdb-9-3-0-release/944 "2026-01-16T16:24:38Z")
Happy new year! Time to update those WHERE timestamp IN '2025' filters. We are kicking off the year with QuestDB 9.3, which packs four major additions: window joins for correlating rows with aggregates from a surroundin… --- ## [QuestDB 9.2.3 is here!](https://community.questdb.com/t/questdb-9-2-3-is-here/941)
**Author:** [@javier](https://community.questdb.com/u/javier)\ **Replies:** 0\ **Last updated:** [December 19, 2025, 4:55pm UTC](https://community.questdb.com/t/questdb-9-2-3-is-here/941 "2025-12-19T16:55:28Z")
An early Xmas present for all of you! :christmas\_tree: QuestDB 9.2.3 focuses on practical performance wins: Faster GROUP BY, improved materialized view refresh behaviour, quicker query compilation for higher throughput,… --- ## [Bind to ipv6 address](https://community.questdb.com/t/bind-to-ipv6-address/208)
**Author:** [@Armin\_Diehl](https://community.questdb.com/u/Armin_Diehl)\ **Replies:** 10\ **Last updated:** [November 27, 2025, 10:16am UTC](https://community.questdb.com/t/bind-to-ipv6-address/208 "2025-11-27T10:16:05Z")
is there a way to bind to an ipv6 address as well, have not found it in the documentation, http.bind.to refers to ipv4 only ? --- ## [WAL sequencerTxn \> writerTxn (and sometimes writerTxn \> sequencerTxn) Data lagging by 2 days in QuestDB 9.2.0](https://community.questdb.com/t/wal-sequencertxn-writertxn-and-sometimes-writertxn-sequencertxn-data-lagging-by-2-days-in-questdb-9-2-0/939)
**Author:** [@Surya\_H](https://community.questdb.com/u/Surya_H)\ **Replies:** 1\ **Last updated:** [November 25, 2025, 1:43pm UTC](https://community.questdb.com/t/wal-sequencertxn-writertxn-and-sometimes-writertxn-sequencertxn-data-lagging-by-2-days-in-questdb-9-2-0/939 "2025-11-25T13:43:28Z")
Hi Team, We are facing an issue with WAL tables after importing data into QuestDB. Issue Summary We observe that sequencerTxn is higher than writerTxn in some WAL tables. At other times, we see the opposite: writ… --- ## [Ead\_parquet() ignores cairo.sql.copy.root and always reads from cairo.sql.copy.export.root](https://community.questdb.com/t/ead-parquet-ignores-cairo-sql-copy-root-and-always-reads-from-cairo-sql-copy-export-root/934)
**Author:** [@mmzz](https://community.questdb.com/u/mmzz)\ **Replies:** 4\ **Last updated:** [November 11, 2025, 10:03am UTC](https://community.questdb.com/t/ead-parquet-ignores-cairo-sql-copy-root-and-always-reads-from-cairo-sql-copy-export-root/934 "2025-11-11T10:03:20Z")
Hello QuestDB team, While testing read\_parquet() on QuestDB 9.1.1 (Build a266bb9…), I noticed it only works when the Parquet file is under cairo.sql.copy.export.root, even though the docs state it should honor cairo.sql… --- ## [Data Compression Info for storage evaluation](https://community.questdb.com/t/data-compression-info-for-storage-evaluation/931)
**Author:** [@tusharbalihalli](https://community.questdb.com/u/tusharbalihalli)\ **Replies:** 5\ **Last updated:** [October 29, 2025, 6:11pm UTC](https://community.questdb.com/t/data-compression-info-for-storage-evaluation/931 "2025-10-29T18:11:20Z")
Hello QuestDB team, I am using QuestDB to store data from Siemens PLC machine (IPC227G). I have setup a data pipeline that uses MQTT and telegraf to route data to QuestDB (which is running fine). Now, I want to estimate… --- ## [Python and questdb console timing discrepency by a large amount](https://community.questdb.com/t/python-and-questdb-console-timing-discrepency-by-a-large-amount/924)
**Author:** [@sjwhitak](https://community.questdb.com/u/sjwhitak)\ **Replies:** 2\ **Last updated:** [October 7, 2025, 5:46pm UTC](https://community.questdb.com/t/python-and-questdb-console-timing-discrepency-by-a-large-amount/924 "2025-10-07T17:46:12Z")
Hello, I have, what I would say, is a standard questdb configuration but reading from the questdb database is incredibly slow. My set up is: questdb-9.0.3 that I downloaded from https://github.com/questdb/questdb/relea… --- ## [Updating a column with an array of rows ](https://community.questdb.com/t/updating-a-column-with-an-array-of-rows/920)
**Author:** [@Janu](https://community.questdb.com/u/Janu)\ **Replies:** 1\ **Last updated:** [September 27, 2025, 12:51pm UTC](https://community.questdb.com/t/updating-a-column-with-an-array-of-rows/920 "2025-09-27T12:51:05Z")
Hi. I have prices stored within a certain time period that need to be updated, it is a lot of rows, and I therefor do not want to update each row individually. Is it possible to use the UPDATE statement with an array o… --- ## [Cannot read WAL event file](https://community.questdb.com/t/cannot-read-wal-event-file/919)
**Author:** [@bcd](https://community.questdb.com/u/bcd)\ **Replies:** 1\ **Last updated:** [September 25, 2025, 2:57pm UTC](https://community.questdb.com/t/cannot-read-wal-event-file/919 "2025-09-25T14:57:56Z")
Hi, I’m new to QuestDB but really liking it so far. During ingestion I’m getting an error repeatedly, although not consistently. I’m using the Python library sending a dataframe. After some number of calls (i.e. 2-5) I… --- ## [Ingested data not querable with weird partition name](https://community.questdb.com/t/ingested-data-not-querable-with-weird-partition-name/917)
**Author:** [@Andre\_Vermeulen](https://community.questdb.com/u/Andre_Vermeulen)\ **Replies:** 1\ **Last updated:** [September 24, 2025, 8:41am UTC](https://community.questdb.com/t/ingested-data-not-querable-with-weird-partition-name/917 "2025-09-24T08:41:08Z")
Hey, I am having an issue where data is ingested into QuestDB (8.3.3) and there seems to be no errors, but if I query the target table there is not recent data in the table; select \* from table\_name order by timestamp d… --- ## [ARM64 Support and Optimization](https://community.questdb.com/t/arm64-support-and-optimization/915)
**Author:** [@pdeng](https://community.questdb.com/u/pdeng)\ **Replies:** 3\ **Last updated:** [September 15, 2025, 12:11am UTC](https://community.questdb.com/t/arm64-support-and-optimization/915 "2025-09-15T00:11:25Z")
Hi QuestDB, I am reading the aws deployment document, it mentions: Architecture QuestDB should be deployed on Intel/AMD architectures i.e. x86\_64 and not on ARM i.e. aarch64. Some optimisations are not available on AR… --- ## [Is there a way to write to QuestDB with Node-Red?](https://community.questdb.com/t/is-there-a-way-to-write-to-questdb-with-node-red/875)
**Author:** [@Starfoxfs](https://community.questdb.com/u/Starfoxfs)\ **Replies:** 20\ **Last updated:** [September 4, 2025, 12:18pm UTC](https://community.questdb.com/t/is-there-a-way-to-write-to-questdb-with-node-red/875 "2025-09-04T12:18:55Z")
Hi, i have installed latest QuestDB 8.3.3 on my Raspberry Pi with Node-Red. Is there a way to write Data over Node-Red to QuestDB ? I know it works over Node.js but Node-Red is more comfortable and i have more Visual F… --- ## [Calculating mode (most frequent digit)](https://community.questdb.com/t/calculating-mode-most-frequent-digit/908)
**Author:** [@javier](https://community.questdb.com/u/javier)\ **Replies:** 6\ **Last updated:** [September 2, 2025, 11:19am UTC](https://community.questdb.com/t/calculating-mode-most-frequent-digit/908 "2025-09-02T11:19:30Z")
Guys, consider I have the following column, whats the best approach to calculate the statistical mode of each row? e.g 1251223 would give me mode of 2. --- ## ["symbol" type is invalid of query](https://community.questdb.com/t/symbol-type-is-invalid-of-query/898)
**Author:** [@LFDCC](https://community.questdb.com/u/LFDCC)\ **Replies:** 6\ **Last updated:** [July 31, 2025, 1:24pm UTC](https://community.questdb.com/t/symbol-type-is-invalid-of-query/898 "2025-07-31T13:24:45Z")
CREATE TABLE 'sys\_telemetry' ( timestamp TIMESTAMP, deviceId INT, propId INT, propValue FLOAT, maxValue FLOAT, maxValueTime TIMESTAMP, minValue FLOAT, minValueTime TIMESTAMP, avgValue FLOAT ) timestamp(timestam… --- ## [Send binary into a column over ILP](https://community.questdb.com/t/send-binary-into-a-column-over-ilp/897)
**Author:** [@Gabriel](https://community.questdb.com/u/Gabriel)\ **Replies:** 1\ **Last updated:** [July 28, 2025, 3:36pm UTC](https://community.questdb.com/t/send-binary-into-a-column-over-ilp/897 "2025-07-28T15:36:16Z")
Hello, I cannot find if the binary type is supported over ILP/HTTP. My table as a column with the binary type that I would like to feed with JPEG streams… Could it be possible ? --- ## [Clarify QDB Upgrades and the hidden .questdb directory](https://community.questdb.com/t/clarify-qdb-upgrades-and-the-hidden-questdb-directory/896)
**Author:** [@paris](https://community.questdb.com/u/paris)\ **Replies:** 1\ **Last updated:** [July 24, 2025, 9:31am UTC](https://community.questdb.com/t/clarify-qdb-upgrades-and-the-hidden-questdb-directory/896 "2025-07-24T09:31:21Z")
I’m upgrading QuestDB for the first time (Linux rt x86). Please clarify how to treat the hidden directory .questdb during an upgrade, which I believe stores all my table data. Can I leave .questdb as is from minor versi… --- ## [How to get the maximum/minimum value's time](https://community.questdb.com/t/how-to-get-the-maximum-minimum-values-time/893)
**Author:** [@LFDCC](https://community.questdb.com/u/LFDCC)\ **Replies:** 9\ **Last updated:** [July 24, 2025, 9:28am UTC](https://community.questdb.com/t/how-to-get-the-maximum-minimum-values-time/893 "2025-07-24T09:28:50Z")
I want to get the maximum and minimum values, as well the maximum value 's time and the minimum value 's time. for example: CREATE MATERIALIZED VIEW weather\_1h AS SELECT ts, max(temperature) maxTemp, --maxTempTime … --- ## [Size per record?](https://community.questdb.com/t/size-per-record/890)
**Author:** [@thewill786](https://community.questdb.com/u/thewill786)\ **Replies:** 1\ **Last updated:** [July 21, 2025, 9:34am UTC](https://community.questdb.com/t/size-per-record/890 "2025-07-21T09:34:34Z")
Hi all! I’m new to QuestDB, and am setting up a test to understand how much space per record it actually uses. Not sure if I’m doing thing correctly, but the results I’m getting are 100.7 bytes per record (which seems t… --- ## [QuestDB 9.0.0 Release](https://community.questdb.com/t/questdb-9-0-0-release/886)
**Author:** [@nwoolmer](https://community.questdb.com/u/nwoolmer)\ **Replies:** 0\ **Last updated:** [July 15, 2025, 3:26pm UTC](https://community.questdb.com/t/questdb-9-0-0-release/886 "2025-07-15T15:26:50Z")
We’re very pleased to announce the release of QuestDB 9.0.0, which brings with it a host of upgrades, including our new datatype - N-dimensional arrays. It is the most feature-rich and robust version of QuestDB so far, … --- ## [Select nearest timestamp from multiple tables](https://community.questdb.com/t/select-nearest-timestamp-from-multiple-tables/885)
**Author:** [@jmthomas](https://community.questdb.com/u/jmthomas)\ **Replies:** 4\ **Last updated:** [July 15, 2025, 10:33am UTC](https://community.questdb.com/t/select-nearest-timestamp-from-multiple-tables/885 "2025-07-15T10:33:32Z")
I’m trying to select from multiple tables values closest (\<=) to the given timestamp. For example in the demo how would I select a few columns from one table and a few columns from another where the timestamp is closest … --- ## [Show parameters](https://community.questdb.com/t/show-parameters/878)
**Author:** [@BepTheWolf](https://community.questdb.com/u/BepTheWolf)\ **Replies:** 2\ **Last updated:** [July 4, 2025, 1:09pm UTC](https://community.questdb.com/t/show-parameters/878 "2025-07-04T13:09:01Z")
Hi, the query: SHOW PARAMETERS WHERE env\_var\_name=‘QDB\_CAIRO\_O3\_MAX\_LAG’; return the error “unexpected token \[WHERE\]”. --- ## [Elapsed time with a value](https://community.questdb.com/t/elapsed-time-with-a-value/877)
**Author:** [@vins](https://community.questdb.com/u/vins)\ **Replies:** 1\ **Last updated:** [July 3, 2025, 4:59pm UTC](https://community.questdb.com/t/elapsed-time-with-a-value/877 "2025-07-03T16:59:55Z")
i have a table (services) that contains the status (0=DOWN, 1=UP) for a service. it’s something like this: timestamp service status 2025-07-02T17:29:40.268000Z ldap 1 2025-07-02T17:29:40.309000Z radius 1 20… --- ## [Unexpectedly high write latency](https://community.questdb.com/t/unexpectedly-high-write-latency/873)
**Author:** [@kidou](https://community.questdb.com/u/kidou)\ **Replies:** 1\ **Last updated:** [June 20, 2025, 10:33am UTC](https://community.questdb.com/t/unexpectedly-high-write-latency/873 "2025-06-20T10:33:50Z")
Hi, can you help me see why my writeTxn always lags behind sequencerTxn so far? I am writing hundreds rows to each table at every 10 seconds. But the data can only be queried after about 1 minute. Here is the screenshot… --- ## [Counting entries based on timestamps](https://community.questdb.com/t/counting-entries-based-on-timestamps/860)
**Author:** [@FulvioFulvioni](https://community.questdb.com/u/FulvioFulvioni)\ **Replies:** 10\ **Last updated:** [June 19, 2025, 8:55am UTC](https://community.questdb.com/t/counting-entries-based-on-timestamps/860 "2025-06-19T08:55:17Z")
Hi! I’m trying to create a query to get some entries in my QuestDB based on some time ranges. The table I have is defined as sessionId (string) | startTime (timestamp) | endTime (timestamp) On any timerange given, whi… [Previous page](https://community.questdb.com/c/community/4.md) [Next page](https://community.questdb.com/c/community/4.md?page=2)