# Wait to sync on new inserted data

**URL:** <https://community.cratedb.com/t/wait-to-sync-on-new-inserted-data/2074>\
**Category:** CrateDB\
**Created:** [September 1, 2025, 9:42am UTC](https://community.cratedb.com/t/wait-to-sync-on-new-inserted-data/2074 "2025-09-01T09:42:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![volker](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/volker/32/1412_2.png) [@volker](https://community.cratedb.com/u/volker)\
**Post date:** [September 1, 2025, 9:42am UTC](https://community.cratedb.com/t/wait-to-sync-on-new-inserted-data/2074/1 "2025-09-01T09:42:07Z")

</div>

Hi!

Is there any feature available that i can wait for the insert query that all date is completely synced over the whole cluster? if i’m to fast after insert, the new data isn’t available at all on a new select query. i’m using the http interface to request and store the data.

thx and regards, volker.

---

<div class="post-metadata">

**Author:** ![amotl](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/amotl/32/617_2.png) [@amotl](https://community.cratedb.com/u/amotl)\
**Post date:** [September 1, 2025, 9:47am UTC](https://community.cratedb.com/t/wait-to-sync-on-new-inserted-data/2074/2 "2025-09-01T09:47:50Z")

</div>

Dear Volker,

thanks for writing in. In CrateDB, to flush write operations wrt. consistency, you can use the `REFRESH TABLE` statement.

> **[REFRESH](https://cratedb.com/docs/crate/reference/en/latest/sql/statements/refresh.html)**
>
> Refresh one or more tables explicitly. Table of contents Synopsis, Description, Parameters, Clauses- PARTITION.. Synopsis: Description: The REFRESH TABLE command refreshes one or more tables, making all changes made to that table visible to...

With kind regards,  
Andreas.

---

<div class="post-metadata">

**Author:** ![matriv](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/matriv/32/613_2.png) [@matriv](https://community.cratedb.com/u/matriv)\
**Post date:** [September 1, 2025, 11:02am UTC](https://community.cratedb.com/t/wait-to-sync-on-new-inserted-data/2074/3 "2025-09-01T11:02:05Z")

</div>

Apart from the `REFRESH` mechanism, for which you can find more details [here](https://cratedb.com/docs/crate/reference/en/latest/sql/statements/create-table.html#sql-create-table-refresh-interval), regarding the configuration of your table(s), it’s also worth taking a look at the [write-wait-for-active-shards](https://cratedb.com/docs/crate/reference/en/latest/sql/statements/create-table.html#write-wait-for-active-shards), which is orthogonal to the refresh mechanism, but lets you configure on how many replicas your data should be synced before an insert is returned as “successful” to the client.

---

<div class="post-metadata">

**Author:** ![volker](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/volker/32/1412_2.png) [@volker](https://community.cratedb.com/u/volker)\
**Post date:** [September 1, 2025, 11:34am UTC](https://community.cratedb.com/t/wait-to-sync-on-new-inserted-data/2074/4 "2025-09-01T11:34:13Z")

</div>

okay, cool ,thx for details!