Title
#users-public
Jone Qiang

Jone Qiang

08/22/2022, 12:03 PM
Hello ,I set cairo.max.uncommitted.rows=1 ,but there are minutes lag when I select from questdb, is it normal ?
Bolek Ziobrowski

Bolek Ziobrowski

08/22/2022, 12:12 PM
Hi @Jone Qiang. MaxUncommittedRows and commitLag setting are stored in table settings at creation time and I don't think they're updated when global values change . You can check table settings with :
select * from tables();
Jone Qiang

Jone Qiang

08/22/2022, 12:17 PM
@Bolek Ziobrowski thanks for your reply. I run this sql, you are right. I change this config, and just restart the questdb, so we cannot change this MaxUncommittedRows after we create table, right?
Alex Pelagenko

Alex Pelagenko

08/22/2022, 12:18 PM
you can, use
ALTER TABLE
Jone Qiang

Jone Qiang

08/22/2022, 12:19 PM
@Alex Pelagenko Thanks 🙏