https://questdb.io logo
Title
a

Andy

02/04/2023, 6:28 AM
• Congratulations!Realse7.0.0 published!the new feature WAL,is very amazing! Consistent ingestion performance, unaffected by out-of-order data processing (2x performance increase on ILP) but how can I switch from ILP to WAL? just add “WAL” in the creating table codes ?
create table ABC(x int, t timestamp) timestamp(t) partition by day WAL;
no need other modification in the inserting codes via InfluxDB Line Protocol? OR rewrite the whole inserting codes?
i

Imre

02/04/2023, 4:29 PM
Hi @Andy, that is the correct syntax to create a WAL table. No change is required on the client. All channels (ILP, PG Wire and HTTP) will automatically ingest data via WAL into the table.
You can also convert existing tables to use WAL. See release notes for more detail. https://github.com/questdb/questdb/releases/tag/7.0.0 Please, note that due to a bug this conversion works via PG Wire only in this version. We have a fix already which will enable converting tables via the REST API (web console). Will be released early next week.
a

Andy

02/04/2023, 5:30 PM
thanks!