# \#question **URL:** https://community.questdb.com/tag/question/8.md [Latest](https://community.questdb.com/latest.md) · [Categories](https://community.questdb.com/categories.md) · [Tags](https://community.questdb.com/tags.md) --- ## [GZip support in ILP ingestion](https://community.questdb.com/t/gzip-support-in-ilp-ingestion/918)
**Author:** [@pdeng](https://community.questdb.com/u/pdeng)\ **Replies:** 5\ **Last updated:** [May 27, 2026, 9:25am UTC](https://community.questdb.com/t/gzip-support-in-ilp-ingestion/918 "2026-05-27T09:25:47Z")
Hi there, InfluxDB supports gzip message to optimise ILP ingestion. Can QuestDB support it? I cannot find anywhere to configure it, or do you have ETA for this feature? Cheers, Paul --- ## [QuestDB Recovery](https://community.questdb.com/t/questdb-recovery/997)
**Author:** [@azuric](https://community.questdb.com/u/azuric)\ **Replies:** 1\ **Last updated:** [May 26, 2026, 5:04pm UTC](https://community.questdb.com/t/questdb-recovery/997 "2026-05-26T17:04:55Z")
hey all, hoping someone can point me at a recovery path before i do something stupid. i had a bulk ingest go sideways and now both my big tables (\`quotes\` ~30B rows / 2 TB, \`trades\` ~1.5B / 95 GB) are suspended with: \`… --- ## [Corrupted table / Metadata read timeout - Cannot disable WAL](https://community.questdb.com/t/corrupted-table-metadata-read-timeout-cannot-disable-wal/992)
**Author:** [@programmerP](https://community.questdb.com/u/programmerP)\ **Replies:** 3\ **Last updated:** [May 15, 2026, 2:12pm UTC](https://community.questdb.com/t/corrupted-table-metadata-read-timeout-cannot-disable-wal/992 "2026-05-15T14:12:28Z")
Hi everyone, I am rather new to QuestDB and really want to use it. Unfortunately I am running into a problem with a corrupted data. When I query my table it returns an error: Metadata read timeout \[src=reader, timeout=… --- ## [How to fix execution time discrepancy curl vs http?](https://community.questdb.com/t/how-to-fix-execution-time-discrepancy-curl-vs-http/989)
**Author:** [@YBrink](https://community.questdb.com/u/YBrink)\ **Replies:** 2\ **Last updated:** [May 12, 2026, 10:33am UTC](https://community.questdb.com/t/how-to-fix-execution-time-discrepancy-curl-vs-http/989 "2026-05-12T10:33:58Z")
I am attempting to run queries using a http client from within a .Net environment. The trouble I’m experiencing is noticeable delays in retrieving data; a delay that does not occur when using curl, or running the query … --- ## [Scaling questdb](https://community.questdb.com/t/scaling-questdb/943)
**Author:** [@Glenn\_Glazer](https://community.questdb.com/u/Glenn_Glazer)\ **Replies:** 4\ **Last updated:** [April 28, 2026, 12:18pm UTC](https://community.questdb.com/t/scaling-questdb/943 "2026-04-28T12:18:49Z")
We are looking at using QDB as a part of a replacement of a part of our pipeline that uses Kafka for both streaming and storage, decoupling the storage part and using QDB for that. What we are interested in at the momen… --- ## [is it possible to show a quick demo on cache the sender objects with python package](https://community.questdb.com/t/is-it-possible-to-show-a-quick-demo-on-cache-the-sender-objects-with-python-package/984)
**Author:** [@Ron321456](https://community.questdb.com/u/Ron321456)\ **Replies:** 1\ **Last updated:** [April 28, 2026, 12:16pm UTC](https://community.questdb.com/t/is-it-possible-to-show-a-quick-demo-on-cache-the-sender-objects-with-python-package/984 "2026-04-28T12:16:48Z")
according to the documentation here: Sending Data over ILP — questdb 3.0.0 documentation “For maxium performance you should also cache the sender objects and reuse them across multiple requests, since internally they ma… --- ## [Poor table to table insert performance, but extremely fast read perf](https://community.questdb.com/t/poor-table-to-table-insert-performance-but-extremely-fast-read-perf/983)
**Author:** [@Nom](https://community.questdb.com/u/Nom)\ **Replies:** 1\ **Last updated:** [April 28, 2026, 12:15pm UTC](https://community.questdb.com/t/poor-table-to-table-insert-performance-but-extremely-fast-read-perf/983 "2026-04-28T12:15:40Z")
Due to the sensitive nature of my workplace, I am using a minimum example which displays the performance issue. The selection speed is phenomenal, but writing seems off. Specs: Storage: 240GB Sata SSD 300MB/s tested … --- ## [Using the JVM QuestDB client on a Raspberry PI 3B?](https://community.questdb.com/t/using-the-jvm-questdb-client-on-a-raspberry-pi-3b/969)
**Author:** [@nielsbasjes](https://community.questdb.com/u/nielsbasjes)\ **Replies:** 5\ **Last updated:** [April 13, 2026, 12:18pm UTC](https://community.questdb.com/t/using-the-jvm-questdb-client-on-a-raspberry-pi-3b/969 "2026-04-13T12:18:19Z")
I currently have a Raspberry Pi 3 Model B Plus Rev 1.3 attached to a device (Heatpump in this case) and I’m using some custom software (based on MiNifi) to send the measurements to a very old InfluxDB. I’m moving to Que… --- ## [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. … --- ## [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… --- ## [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… --- ## [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… --- ## [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… --- ## [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 … --- ## [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… --- ## [Is there a way to have timezoned day partitions?](https://community.questdb.com/t/is-there-a-way-to-have-timezoned-day-partitions/870)
**Author:** [@SJC](https://community.questdb.com/u/SJC)\ **Replies:** 1\ **Last updated:** [June 18, 2025, 2:24pm UTC](https://community.questdb.com/t/is-there-a-way-to-have-timezoned-day-partitions/870 "2025-06-18T14:24:06Z")
Hi, I am currently developing an app that handles iot data in a local facility. I have tables that store iot data that is partitioned by day. The partition is kept for a month and expired partitions are dropped by our s… --- ## [Query data delay](https://community.questdb.com/t/query-data-delay/866)
**Author:** [@Oldman](https://community.questdb.com/u/Oldman)\ **Replies:** 3\ **Last updated:** [June 17, 2025, 5:14pm UTC](https://community.questdb.com/t/query-data-delay/866 "2025-06-17T17:14:07Z")
Hi, I recently use the questdb to store trades and candlestick data, the “candlestick” table works well, However, the data inserted into the “trades” table cannot be queried immediately. seems it will delay for few hour… --- ## [Math operations with lag()](https://community.questdb.com/t/math-operations-with-lag/820)
**Author:** [@vins](https://community.questdb.com/u/vins)\ **Replies:** 21\ **Last updated:** [June 17, 2025, 12:07pm UTC](https://community.questdb.com/t/math-operations-with-lag/820 "2025-06-17T12:07:16Z")
i have a questdb 8.3.0 and i want to graph a typical snmp counter containing network incoming traffic (ifHCInOctets). if i run this query: SELECT timestamp, ifDescr, ifHCInOctets, (LAG(ifHCInOctets,1)… --- ## [Is there a way to LAG() with VARCHAR data?](https://community.questdb.com/t/is-there-a-way-to-lag-with-varchar-data/855)
**Author:** [@germsvel](https://community.questdb.com/u/germsvel)\ **Replies:** 2\ **Last updated:** [June 11, 2025, 2:39pm UTC](https://community.questdb.com/t/is-there-a-way-to-lag-with-varchar-data/855 "2025-06-11T14:39:02Z")
:waving\_hand: hi there, I’m trying out QuestDB for the first time, so this testing is in dev (i.e. not sure if the enterprise edition has differences). One of the things I’m trying to do is find rows in a dataset whose… --- ## [Know when rows are ready for select?](https://community.questdb.com/t/know-when-rows-are-ready-for-select/834)
**Author:** [@BepTheWolf](https://community.questdb.com/u/BepTheWolf)\ **Replies:** 3\ **Last updated:** [May 16, 2025, 11:42am UTC](https://community.questdb.com/t/know-when-rows-are-ready-for-select/834 "2025-05-16T11:42:22Z")
Hi, I’m here again… When I insert some rows and immediately after I do a select, it return the rows without the last insert. If I wait 1 seconds before doing the select the result is correct. Is there any way to know … --- ## [QuestDB High CPU Usage with Table-Per-Metric Approach (Ex-InfluxDB Refugee)](https://community.questdb.com/t/questdb-high-cpu-usage-with-table-per-metric-approach-ex-influxdb-refugee/826)
**Author:** [@kowen](https://community.questdb.com/u/kowen)\ **Replies:** 4\ **Last updated:** [May 2, 2025, 8:24pm UTC](https://community.questdb.com/t/questdb-high-cpu-usage-with-table-per-metric-approach-ex-influxdb-refugee/826 "2025-05-02T20:24:15Z")
Background We’re enterprise users who recently started considering our options after InfluxData limited features in their V3 core offering. Our application tracks system metrics in a radar control system, writing data at… --- ## [Influxdb migration idea](https://community.questdb.com/t/influxdb-migration-idea/823)
**Author:** [@David\_Goadby](https://community.questdb.com/u/David_Goadby)\ **Replies:** 2\ **Last updated:** [May 2, 2025, 1:05am UTC](https://community.questdb.com/t/influxdb-migration-idea/823 "2025-05-02T01:05:36Z")
Like a lot of Influxdb users I am pi\*\*ed of about their new policies. I am still on V1 and was looking forward to upgrading to V3. Time for a change… I did look at TDengine and they have a perfect way of migrating as th… [Next page](https://community.questdb.com/tag/question/8.md?match_all_tags=true&page=1&tags%5B%5D=question)