Jone Qiang

    Jone Qiang

    1 month ago
    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

    1 month ago
    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

    1 month ago
    @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

    1 month ago
    you can, use
    ALTER TABLE
    Jone Qiang

    Jone Qiang

    1 month ago
    @Alex Pelagenko Thanks 🙏