I joined Lemmy back in 2020 and have been using it as qaz@lemmy.ml until somewhere in 2023 when I switched to lemmy.world. I’m interested in systemd/Linux, FOSS, and Selfhosting.

  • 269 Posts
  • 1.97K Comments
Joined 2 years ago
cake
Cake day: June 10th, 2023

help-circle











  • qaz@lemmy.worldtoScience Memes@mander.xyzBird
    link
    fedilink
    English
    arrow-up
    10
    ·
    edit-2
    2 days ago

    This reminds me of an old family story. My grandpa used to have an uncle who had flamingo’s. Imagine walking through a Dutch village somewhere in the 60’s and seeing a bunch of flamingo’s standing in some muddy ditch. I have have no clue how he they ended up there, but it apparently wasn’t the first time he ended up with some tropical animal. My grandpa had to take care of them for a while, but didn’t really know what to feed them. He also had some parrots and would buy food for them from the miller. Considering these were also birds, just larger, he went to the miller and asked for food for flamingo’s. The miller did not know what flamingo’s were. He therefore explained that they were large pink birds. The miller was not convinced, thinking he was pulling his leg and sent him away with a few bags of chicken feed.


















  • qaz@lemmy.worldtoProgrammer Humor@programming.devGood Morning
    link
    fedilink
    English
    arrow-up
    12
    ·
    edit-2
    14 days ago

    I’ve been using ClickHouse too and it’s significantly faster than Postgres for certain analytical workloads. I benchmarked it and while Postgres took 47 seconds, ClickHouse finished within 700ms when performing a query on the OpenFoodFacts dataset (~9GB). Interestingly enough TimescaleDB (Postgres extension) took 6 seconds.

    Insertion Query speed
    Clickhouse 23.65 MB/s ≈650ms
    TimescaleDB 12.79 MB/s ≈6s
    Postgres - ≈47s
    SQLite 45.77 MB/s1 ≈22s
    DuckDB 8.27 MB/s1 crashed

    All actions were performed through Datagrip

    1 Insertion speed is influenced by reduced networking overhead due to the databases being in-process.

    Updates and deletes don’t work as well and not being able to perform an upsert can be quite annoying. However, I found the ReplacingMergeTree and AggregatingMergeTree table engines to be good replacements so far.

    Also there’s !clickhouse@programming.dev