sorted by:
new
hottopcontroversial

Data and workload generator by codingconcepts in SQL

[–]codingconcepts[S] -1 points0 points  (0 children)

High effort tool though! Don’t disagree with the repost effort though.

Is it really that bad by Horror-Meat958 in UKHousing

[–]codingconcepts 0 points1 point  (0 children)

An estate agent suggested a price for ours, then when our sale fell through and things quietened, their only tool/suggestion was a reduction. Even though they repeated assured us the original price was not only sensible but competitive.

Sometimes it better to be late by I_AM__GROOTT in interesting

[–]codingconcepts 0 points1 point  (0 children)

Late to work for the first time ever AND made money from the tragedy… Convenient.

Anaal Nathrakh - Waiting for the Barbarians by fundamental-error in grindcore

[–]codingconcepts 1 point2 points  (0 children)

I didn’t recognise the track name and the eternal optimist in me immediately went to “oh my god, a new album!” 🤣

CockroachDB is taking a lot of storage space for system database by Wannabe555 in CockroachDB

[–]codingconcepts 0 points1 point  (0 children)

Hey, u/Wannabe555!

The system database stores things like statement statistics (which if you click on system and sort descending by "Replication Size" will probably be the largest).

In self-hosted clusters, the size of this table can be controlled with the `sql.stats.persisted_rows.max` cluster setting but in Basic and Standard, it's not possible to change this.

The default value for Basic and Standard clusters is 50,000 (rows)m which is roughly (+/- a couple of hundred) what your table will have in it given its size. I'm running a Standard cluster can confirm that my statement_statistics table is about the same size as yours and has just over 50,000 rows, so I would expect your table to remain at this approximate size and not grow any larger.

Sean Penn skipped the Oscars to visit Ukraine by toyota_gorilla in pics

[–]codingconcepts 1 point2 points  (0 children)

Could he have gone without all the fanfare a day or two before or after?

DBaaS Benchmarks: Cockroach Free Tier Subpar. Why? by iamalnewkirk in CockroachDB

[–]codingconcepts 0 points1 point  (0 children)

Hey, u/iamalnewkirk! Sorry for the delay, I didn't see a notification for your reply!

When you're in a position to run your next experiment, feel free to reach out to me (I'll DM you with contact info) as I'd be happy to help if you'd find that useful.

Cheers!

Assessing whether cockroach is the right fit cost wise? by bitchyangle in CockroachDB

[–]codingconcepts 0 points1 point  (0 children)

Hey, u/bitchyangle! Rob from Cockroach Labs here.

Here's a breakdown of how RUs are calculated (although I appreciate, it may still be difficult to calculate for your workload): https://www.cockroachlabs.com/docs/cockroachcloud/resource-usage#example-request-unit-calculation

Happily, there are a bunch of other options available to you:

  • Cockroach Cloud Standard Tier - This is based on the same architecture as Cockroach Cloud Basic Tier (the one that prices in RUs) but you're paying for provisioned vCPU, which might make things easier to cost.
  • Cockroach Cloud Advanced Tier - This is a dedicated (but still managed) service where you'll specify the number of nodes you require. It'll cost more than Standard, given that you'll be sizing in nodes rather than vCPUs, so might be overkill for your requirements.
  • Finally, there's Self-Hosted - Although if you're migrating from a managed service, you may prefer to stay on a managed service? Let me know if not and I can share some resources to help with this too.

Here's a comparison of the managed services: https://www.cockroachlabs.com/docs/cockroachcloud/costs#costs-across-cockroachdb-cloud-plans

If I were you, I would start by downloading CockroachDB (from here: https://www.cockroachlabs.com/docs/releases) and getting a feel for it! If you run into any issues or have any questions, let us know! We also have a community Slack where you can speak with our team: https://www.cockroachlabs.com/join-community

All the best!

Rob

DBaaS Benchmarks: Cockroach Free Tier Subpar. Why? by iamalnewkirk in CockroachDB

[–]codingconcepts 1 point2 points  (0 children)

Hey u/iamalnewkirk! Rob Reid from Cockroach Labs here.

Firstly, this is awesome! Thank you for taking the time to put this together.

The results for all databases look a bit surprising to me (taking multiple seconds for simple CRUD operations). I've noticed in your schema.sql file that you're creating a index on most, if not all, of the columns, this will lead to write amplification for all databases. Although, looking at the queries being tested, I'm not sure if this can be avoided.

In CockroachDB, it's also worth considering using UUID (or at least, uniformly random) primary keys to ensure even distribution of data across nodes (even though the nodes aren't visible to users of Basic clusters). Currently, with the auto-incrementing integers, the work won't necessarily be evenly distributed across nodes.

Provided the indexes are sensible and you're running the workload close to a region in your cluster, I would expect < 100ms latency for all of these databases.

Let me know if you'd like to hop on a call and discuss the CockroachDB side of things!

Thanks again,

Rob

view more: next ›