• guorui an

    guorui an

    2 months ago
    ohh, i see Choose the
    PostgreSQL
    plugin and configure it, right? don't have quest self plugin
    guorui an
    Andrey Pechkurov
    2 replies
    Copy to Clipboard
  • Pei

    Pei

    2 months ago
    Hi @Pankaj Khandelwal welcome! 👋
    Pei
    1 replies
    Copy to Clipboard
  • Manoj DeSilva

    Manoj DeSilva

    2 months ago
    Hi Team, Is there any way to check the current configuration of a running QuestDB instance. I have disabled the http.query.cache by setting environment variable as QDB_HTTP_QUERY_CACHE_ENABLED="FALSE" . Now I want to check whether QuestDB correctly picked this config, because it seems like cache is still enabled because questDB is printing log lines similar to below.
    2022-07-26T06:06:00.253499Z I i.q.c.h.p.QueryCache hit [thread=questdb-worker-3, sql=SHOW TABLES]
    Manoj DeSilva
    Bolek Ziobrowski
    4 replies
    Copy to Clipboard
  • Pei

    Pei

    1 month ago
    Hi @Tibor welcome!
    Pei
    1 replies
    Copy to Clipboard
  • m

    Miloš Kozák

    1 month ago
    👋 Hello, team! I am glad to be here, and I am glad to let you know I have just opened an issue on github for you https://github.com/questdb/py-questdb-client/issues/4. Just wonder, if I am pushing a little bit to hard?
    m
    j
    2 replies
    Copy to Clipboard
  • d

    Dave

    1 month ago
    Hey team, I have a quick question about partition attachment mechanics. The docs read:
    "This feature is designed to support attaching partitions from a backup or copying and attaching partitions across a network between QuestDB instances."
    A few lines down though, there's this disclaimer:
    Moving partitions between tables or database instances is not supported.
    If a user has multiple active instances of quest, is it possible to detach a partition from instance A and attach it to instance B?
    d
    Pei
    +1
    7 replies
    Copy to Clipboard
  • Emmett

    Emmett

    1 month ago
    Getting an unexpectedly high latency on a relatively simple query:
    select ts, last(close) from 'ohlc_exchanges' where pair in 'btc-usd' and exchange in 'coinbase' and ts >= cast(1608864755 * 1000000L AS TIMESTAMP) and ts <= cast(1656125555 * 1000000L AS TIMESTAMP) sample by 1d align to calendar with offset '00:00' limit 5000
    Table has ~65M rows.
    pair
    and
    exchange
    are indexed and the table is partitioned by month. QDB 6.4.1. Query takes about 6000ms. I have a similar table w/ ~25M rows that does not have the
    exchange
    column, and similar queries on this table take around 200ms. Does anyone have an idea of how I might be able to increase performance on this query? I’m sure I’m doing something wrong.
    Emmett
    Andrey Pechkurov
    21 replies
    Copy to Clipboard
  • s

    Stefan S

    1 month ago
    Hi, trying to figure out if the code or the docs is broken: Consider the
    last
    aggregate function:
    CREATE TABLE test(ts TIMESTAMP, value FLOAT);
    INSERT INTO test VALUES ('2020', 1.0);
    INSERT INTO test VALUES ('2021', 2.0);
    SELECT last(value) FROM test;
    Actual result is:
    2.0
    I had expected an error message, as the docs say the
    last
    function only applies to columns of type
    SYMBOL
    . Am I doing something wrong?
    s
    Jaromir Hamala
    7 replies
    Copy to Clipboard
  • Jone Qiang

    Jone Qiang

    1 month ago
    use lots of select last function, made the server crash. and with this error :Event: 264670.620 Thread 0x00007fbe3d64d800 Exception <a 'java/lang/InternalError'{0x000000076292b3b8}: a fault occurred in a recent unsafe memory access operation in compiled Java code> (0x000000076292b3b8) thrown at [./src/hotspot/share/runtime/thread.cpp, line 2237], Has anyone seen it,questdb version 6.4.1
    Jone Qiang
    Pei
    +1
    4 replies
    Copy to Clipboard
  • Newskooler

    Newskooler

    1 month ago
    hi 👋 what is the max amount if ILP records that can be send on a single data dump?
    Newskooler
    Vlad
    3 replies
    Copy to Clipboard