Flushing buffer tables before restarting clickhouse

[Kenji]

I have a BUFFER engine table that is attached to a MergeTree table for persistence.

Does CH flush the content of BUFFER tables to the persistent table when the CH server process is being shutdown?

For now,  I run "OPTIMIZE TABLE mybuffertable"  to flush it before shutting it down.

-kenji

[Denis Zhuravlev]

When the server is stopped, with DROP TABLE or DETACH TABLE, buffer data is also flushed to the destination table.

https://clickhouse.tech/docs/en/engines/table-engines/special/buffer/

[Kenji]

Great! I should've read the doc more carefully. Thanks!

> --
> You received this message because you are subscribed to the Google Groups "ClickHouse" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to clickhouse+...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/clickhouse/b25c2935-398b-4c73-9549-3075b6887bbcn%40googlegroups.com.