• p

    Prashanthb

    3 months ago
    Hi QueastDB team ! I am new here and still reading the docs. I am thinking of working with some low powered x86-64 hardware now. One of my CPUs does not have AVX. Another CPU of mine has AVX but not AVX2. However both of those CPUs have SSSE3 and SSE4.1 Does this mean I will miss out on some JIT acceleration ? How much of a drawback is this ? I work with stock market data and do lot of WHERE timestamp range selects with sum/avg/max/min. Thank you.
    p
    Andrey Pechkurov
    3 replies
    Copy to Clipboard
  • Pei

    Pei

    3 months ago
    Hi @Parwez welcome!
  • Wyatt Miller

    Wyatt Miller

    3 months ago
    Hi guys. I am running “Insert into ‘x’ select * from ‘y’ where pair != ‘btc-usd’’“, then i query table x and btc-usd still exists. I looked at the documentation and I seem to be doing it right. Am I missing something?
    Wyatt Miller
    Alex Pelagenko
    +1
    7 replies
    Copy to Clipboard
  • Newskooler

    Newskooler

    3 months ago
    Hi 👋 I have asked this question a bunch of times, but every time I seem to be stuck on it: Is there a way to see which column is the
    designated timestamp
    column for a particular table from the UI?
    Newskooler
    Alex Pelagenko
    4 replies
    Copy to Clipboard
  • Domnic Amalan

    Domnic Amalan

    3 months ago
    hi i nedd query help in questdb
  • Domnic Amalan

    Domnic Amalan

    3 months ago
    How do i update if not exists insert
  • s

    Shimon Doodkin

    3 months ago
    how to understand the source of high cpu?
    s
    Andrey Pechkurov
    4 replies
    Copy to Clipboard
  • Newskooler

    Newskooler

    3 months ago
    Not exactly a QDB internals question, but I believe someone may have hit a similar issue here and may be able to help me. I am running QDB on an Ubuntu cloud server. The server has a firewall enabled and blocking everything besides ssh. Despite this, when (on a separate machine and outside the server) I run something like:
    curl -G --data-urlencode "query=tables()" <http://ip_address:9000/exp>
    I get the result… which is supposed to be blocked. Any ideas what I am doing wrong here? 🤔 P.S. I am running QDB via docker and exposing the ports via docker to the same ports as original.
    Newskooler
    Marius Gheorghies
    18 replies
    Copy to Clipboard
  • Pei

    Pei

    3 months ago
    Hello <!here> 🙂 this Tuesday we are joining DataOps Poland meetup and will give a talk about timeseries databases with a small demo & workshop. It’s an online event and the talk will be in English. Welcome to join us! 👋 https://www.meetup.com/dataops-poland/events/286113262/
    Pei
    j
    3 replies
    Copy to Clipboard
  • Ning Hale

    Ning Hale

    3 months ago
    Hi , Happy to join questdb community.👋