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 when rows are ready for select? Or force a flush like PostgreSQL’s “ALTER SYSTE…

Hi @BepTheWolf , Transactions are applied asynchronously. When you insert data, it is first committed to WAL. Then a separate job applies the WAL to the table files. wal_tables() gives you the writerTxn and sequencerTxn numbers for your table. writerTxn is the latest visible txn. sequencerTxn is…

[image] nwoolmer: you need ensure the writerTxn number is higher than a sequencerTxn number you check after a successful insert The wal_tables() function seems like a good solution for my tests. Should the value of writerTnx be greater, or greater/equal to sequencerTnx?

For a particular table, it is always the case that writerTxn <= sequencerTxn. sequencerTxn tells you how many transactions are committed (inserted to database). writerTxn tells you how many transactions are applied (visible for read). INSERT data A Tick wal_tables() and assign sequencerTxn_a to …

Know when rows are ready for select?

Community

BepTheWolf May 16, 2025, 11:36am 3

The wal_tables() function seems like a good solution for my tests.

Should the value of writerTnx be greater, or greater/equal to sequencerTnx?

Topic		Replies	Views
How to await for rows ingested to WAL table to become visible in QuestDB? Community sql , question	1	203	June 26, 2024
WAL sequencerTxn > writerTxn (and sometimes writerTxn > sequencerTxn) Data lagging by 2 days in QuestDB 9.2.0 Community question	1	77	November 25, 2025
Unexpectedly high write latency Community config , question	1	108	June 20, 2025
New rows not ingested into existing table Community	13	593	July 12, 2024
Query data delay Community question , client	3	122	June 17, 2025

Know when rows are ready for select?

Related topics