• Hasitha Dharmasiri

    Hasitha Dharmasiri

    1 month ago
    is there anything other than
    commit.lag
    and
    max.uncommitted.rows
    in
    server.conf
    that could cause O3 (or other) commit lag in Quest? I'm seeing data back up for 10 minutes sometimes before I can query it, despite
    commit.lag=1000
    . Been scouring the documentation but haven't found anything yet so I figured I would ask. they are quite often specific tables, so I'm generally convinced it isn't MQ buffering in our ingestion layer, which doesn't discriminate by table. we're ingesting via ILP
    Hasitha Dharmasiri
    Andrey Pechkurov
    +1
    5 replies
    Copy to Clipboard
  • Newskooler

    Newskooler

    1 month ago
    I am having an issue: When I insert large amounts of data (millions of rows) into a table, the QDB instance at some point freezes… It’s happening on version 6.4.2 The data is OOO (I try to make it ordered), so I suspect this may be it…. I insert via ILP. Not sure what more I can share to debug this. Does anyone else experience similar issues?
    Newskooler
    Nicolas Hourcard
    7 replies
    Copy to Clipboard
  • j

    Jack

    1 month ago
    Hello - Is it possible to do a "where in" but for the "in" clause provide a select query which generates a list of timestamps?
    j
    Alex Pelagenko
    37 replies
    Copy to Clipboard
  • Nicolas Hourcard

    Nicolas Hourcard

    1 month ago
    hi @Mehrdad Jalali welcome
  • Newskooler

    Newskooler

    1 month ago
    Does anyone have a python function for converting a pandas.DataFrame to ILP? 😃
    Newskooler
    Nicolas Hourcard
    +1
    7 replies
    Copy to Clipboard
  • Pei

    Pei

    1 month ago
    Hi @Hữu Thắng Dương @Jan @Woradorn Laodhanadhaworn @Max Niederman @pok liu welcome to the community! 👋
  • m

    Max Niederman

    1 month ago
    Is there a way that I could query a timestamp field as a delta from the last timestamp?
    m
    1 replies
    Copy to Clipboard
  • 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 ?
    Jone Qiang
    Bolek Ziobrowski
    +1
    5 replies
    Copy to Clipboard
  • Sergey Georgiev

    Sergey Georgiev

    1 month ago
    Hi all. How much operation memory is expected QuestDB to consume if I have 5GB data on the disk.
    Sergey Georgiev
    Bolek Ziobrowski
    4 replies
    Copy to Clipboard
  • João Calapez

    João Calapez

    1 month ago
    Hello, i'm trying to find a way to change the name of the database from qdb to something else, I was expecting to see something in line with pg.password or pg.user, but cant find anything that defines this, any light on this?
    João Calapez
    Jaromir Hamala
    11 replies
    Copy to Clipboard