Viewing profile — andydb

We're working on enabling PostgREST. There is some small-ish functionality that we need do in CockroachDB for it to fully work.

We're still discussing options there, so I don't have an answer on how we might handle them. We do recognize that many business customers will have such requirements.

We haven't run into that so far, but thank you for pointing it out as something to watch out for.

I think you're right on target with the multi-tenant SAAS services. They often suffer from the "long-tail" problem, where the tiny customers without much usage cost too much to hos…

At this point, only Postgres SSL connections are supported.

Our product roadmap will be heavily influenced by customer asks. So if there are things about CockroachDB Serverless that prevent you from using it (like requiring ingress through …

Yes, definitely, we'll be expanding to more regions soon.

Sure, those are all good points. We'll definitely keep an eye on customer demand in these areas so we can make good prioritization decisions. It can be frustrating when there are s…

It's been something we've done since the start and plan to continue doing. If you read back over our engineering blog, you'll find a surprisingly thorough description of the entire…

Oh boy, I'm an engineer, but I'll do my best to pretend I'm on the sales or marketing team for a minute... First of all, CockroachDB Serverless is available on AWS, and should inte…

It's not currently possible, partly because it complicates the deployment model quite a bit. Dynamically bringing SQL pods up and down requires a technology like Kubernetes. It tak…

You've run into a "rough edge" of the beta release that will be fixed soon. When you keep the Cluster Overview page open, it runs queries against your cluster so that it can displa…

Great question. We recognize how important this is and are actively working on it.

To any who might see this, I'm the author of the blog post, and led the engineering team that built CockroachDB Serverless. I'll be monitoring this thread in case there are any que…

Re. 1, doesn't the majority set of logs for a given logical sequencer need to overlap with the majority set of logs for each other logical sequencer? If not, I don't see how you gu…

FaunaDB has to make painful (to applications) tradeoffs between latency and consistency in global scenarios: 1. All read-write transactions pay global latency to a central sequence…

Database tuning tools are not on the near-term roadmap, but I think it's a good idea that we'll want to look at eventually. Using ML to self-tune databases is a hot research subjec…

SELECT * FROM a, b WHERE a.x = b.x AND a.y='foo' AND b.z='bar' The best plan for this simple query depends on the selectivity of the predicates. For example, if 20k rows have a.y='…

We've talked about ideas along those lines. However, rather than altering the plan mid-query, we'd be more likely to have some kind of feedback mechanism that corrects estimates fo…

This is not a book, but we did write up some documentation for developers that gives a nice overview of how the optimizer works: https://github.com/cockroachdb/cockroach/blob/maste…

I think you're right; I'm a chess player, and working on the optimizer does hit some of the same neural pathways.

Interesting MSR paper. With regards to Orca, we did take a look at it. It's an OLAP optimizer written in C++ (and very lightly commented and documented, unfortunately), and we want…

Yes, that would be clearer language. I'll look into updating the text.

To be clear, the Exodus/Volcano/Cascades foundation includes more than just the Memo. Also important is the idea that you can declaratively define rewrite rules and generate parts …

Postgres and MySQL both do calculate costs. One difference is that they are not based around the Memo data structure (someone correct me if I'm wrong about that!), which gives an e…