Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Apr 15 18:14
    vivekmenezes closed #36840
  • Apr 15 18:14
    vivekmenezes commented #36840
  • Apr 15 18:13
    cockroach-teamcity commented #36848
  • Apr 15 18:13
    vivekmenezes review_requested #36848
  • Apr 15 18:13
    vivekmenezes review_requested #36848
  • Apr 15 18:13
    vivekmenezes opened #36848
  • Apr 15 18:10

    craig[bot] on staging.tmp

    (compare)

  • Apr 15 18:10

    craig[bot] on staging

    exec/colserde: add arrow format… Merge #36578 36578: exec/colse… (compare)

  • Apr 15 18:10

    craig[bot] on staging.tmp

    exec/colserde: add arrow format… [ci skip] -bors-staging-tmp-365… (compare)

  • Apr 15 18:10

    craig[bot] on staging.tmp

    [ci skip] (compare)

  • Apr 15 18:10
    asubiotto commented #36578
  • Apr 15 18:09
    craig[bot] closed #36844
  • Apr 15 18:09
    craig[bot] closed #36643
  • Apr 15 18:09
    craig[bot] closed #36838
  • Apr 15 18:09
    craig[bot] closed #36817
  • Apr 15 18:08
    craig[bot] commented #36844
  • Apr 15 18:08
    craig[bot] commented #36838
  • Apr 15 18:08

    craig[bot] on master

    roachprod: distributed authoriz… changefeedccl: deflake TestChan… workload,workloadccl: standardi… and 3 more (compare)

  • Apr 15 18:08
    craig[bot] commented #36817
  • Apr 15 17:52
    ajwerner edited #36838
kena
@knz
benchmarks when comparing databases. Look for something like TPC-C numbers.
(20:10) < andreimatei>
(20:10) < andreimatei> On more reasonable benchmarks, CRDB wins. With the 19.2 version that's currently in the "release candidate" phase, even on their unfortunate benchmark, the different is much smaller. In fact, we do a lot better than YDB on the case with secondary indexes.
(20:10) < andreimatei>
(20:10) < andreimatei> Anyway, performance aside, CRDB is a much more mature database. Try them both and you'll surely agree.
(20:10) < andreimatei> Plus, the architecture is the right one for a distributed database - distribution awareness at all layers. Cockroach has a distributed execution engine (we compile joins, aggregations, etc into components running in a distributed manner) versus YDB which uses a (single node) Postgres
execution engine on top of distributed storage.
code-chat
@code-chat
@knz i'm trying to create a new table based on a different sort order then the original table
kena
@knz
@code-chat: the native order in tables is determined by the primary index. If you want a different "default sort order" you need a different primary index.
kena
@knz
@code-chat: perhaps some of your confusion stems from the fact crdb auto-creates a primary index if you don't specify one. The auto-PK is more-or-less a "rowid" column that's auto-populated with something that (vaguely) looks like a counter. Because of this default, you have the impression that insertion order matters.
code-chat
@code-chat
@knz well my confusion is from that ORDER BY works for insert statements in postgres
kena
@knz
but it doesn't really. SQL is a declarative language, and it does not mandate that mutations are performed in a particular order.
code-chat
@code-chat
but are ignored here
kena
@knz
even in postgres you'd get weird results if you were to use the new parallel execution in pg 11 or 12
that being said
let me have a look
ok I acknoweldge that our docs are unclear on this topic. I will make an improvement to them.
swinSpo
@swinSpo
@knz thanks for the perspective, could cockroachdb do a benchmark comparing yugabytedb with cockroachdb? I would be very interested in the numbers
kena
@knz
@code-chat: see cockroachdb/cockroach#42058
Nathan VanBenschoten
@nvanbenschoten
@swinSpo we've taken the stance that we'd like to avoid publishing benchmark results for other databases, as it's dangerously easy to misrepresent others and come across as disingenuous. https://medium.com/@PingCAP/why-benchmarking-distributed-databases-is-so-hard-2765a26cc2bf provides a good perspective on why this is so hard.
Nathan VanBenschoten
@nvanbenschoten
We've also favored publishing benchmark results for transactional benchmarks like TPC-C in the past because those are closer to the workloads users of CockroachDB actually run, but these are even harder to tune properly across different databases. That said, we recognize that there is a use for "microbenchmark" style benchmarks running non-transactional workloads like sysbench. We've been building out https://www.cockroachlabs.com/docs/dev/performance.html to provide information about how CockroachDB performs both on transactional and non-transactional workloads, with a focus on using industry-standard benchmarks.
Nathan VanBenschoten
@nvanbenschoten
Reproduction steps for all results published there are coming in the next few weeks.
lsraj
@lsraj
I have table in CRDB with key-value pair (value is JSONB). If I add new fields into JSONB, is there a tool to migrate from older to newer JSONB? Also if I change the table names, how do I migrate ? Thanks.
Kelly Sommers
@kellabyte
is it possible to implement a CAS operation with CockroachDB?
Ben Darnell
@bdarnell
@kellabyte I don't think there's a one-statement way to get compare-and-swap (cockroachdb/cockroach#28956). You can do it with multiple statements in a transaction (which will have the correct semantics but maybe not the performance you're looking for). Slightly weaker forms like compare-and-set are doable with an UPDATE statement
Kelly Sommers
@kellabyte
@bdarnell I think that is good enough, I'm trying to understand what our current thing is doing so that I can try to understand how to make it work in CRDB
István Soós
@isoos
@kellabyte: you can have a simple tracking column for incremental data version, and then UPDATE table SET value=123, version=2 WHERE version=1 AND id=234;?
Kelly Sommers
@kellabyte
@isoos if I already have a field I know I can check I can avoid the version column right?
István Soós
@isoos
@kellabyte yeah, sure, but you probably want to mutate that field to prevent concurrent updates overriding each other.
mert
@volknanebo
hi
when i'm doing clustering , my QPS falling down so fast
from thousands to hundreds
almost 10x
mert
@volknanebo
sh-3.2# cockroach gen haproxy --host=127.0.0.1:26257 --certs-dir=./certs/clientkey
Error: initial connection heartbeat failed: rpc error: code = Unknown desc = version compatibility check failed on ping request: cluster requires at least version 19.1, but peer has version 2.1
Failed running "gen haproxy"
HashtagGo
@HashtagGo
hi
I'm using docker-compose in Development and also in Product . if i want to do query (get data from cockroachdb) through docker . How to do this ?
Thanks in Advance
version: '3'
services:
  cockroachdb:
    container_name: cockroachdb
    image: cockroachdb/cockroach:v2.1.6
    command: start --insecure --store=attrs=ssd,path=/var/lib/cockroach/
    restart: always
    volumes:
      - data:/var/lib/cockroach
    expose:
      - "8080"
      - "26257"
    ports:
      - "26257:26257"
      - "8080:8080"
Jordan Lewis
@jordanlewis

Gitter folks! Thank you all so much for participating in this community with us. We really value the ability to chat back and forth about CockroachDB and related topics - which is why we’re inviting all of you to join our CockroachDB Community Slack workspace. Our hope is that Slack will be a better environment for growing this community to reach more people and answer more questions. We’re inviting you before we announce the Slack channel to the general public so that you can get in early and grab your prefered user name. Here is the link: https://join.slack.com/t/cockroachdb/shared_invite/enQtODE2MjY0MDA3OTIxLTQxNWNlOTAzYTlkOTdlZTljMzM4ZTZjMjU5ODcyZjUzYzIyMzIzMjZkY2ZmOWU0OTBkYmNlMjc4YTg5NzE3YTQWe

We will be deprecating our Gitter on November 20th, so please jump into Slack before then. Thanks for everything and we’ll see you in Slack!

Kelly Sommers
@kellabyte
@jordanlewis: is that invite link working? slack says it’s expired
it also says you need a cockroach labs email address
Kelly Sommers
@kellabyte
I want to join the slack!
Jordan Lewis
@jordanlewis
Hmm! That's not good...
Kelly Sommers
@kellabyte
trying!
yup that worked!
would you be able to enable the irccloud integration option to please? a lot of people use this to consolidate all their slacks and gitters and irc channels into one interface. it works great with slack
I keep all my slacks in one place using irccloud
Jordan Lewis
@jordanlewis
we did enable irccloud - is it not working for you?
HashtagGo
@HashtagGo
how to multiple nodes of cockraoch db through docker-compose and how to join them
Jordan Lewis
@jordanlewis

Check out our Slack instance: This Gitter will be deprecated on November 20th. Thanks!

https://cockroa.ch/slack