andydb

6 ms·

1.
by andydb 5y ago
We're working on enabling PostgREST. There is some small-ish functionality that we need do in CockroachDB for it to fully work.
2.
by andydb 5y ago
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.
3.
by andydb 5y ago
We haven't run into that so far, but thank you for pointing it out as something to watch out for.
4.
by andydb 5y ago
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 host. And of course, that's one of the big
5.
by andydb 5y ago
At this point, only Postgres SSL connections are supported.
6.
by andydb 5y ago
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 a public IP), we definitely want to hear about it. Regarding
7.
by andydb 5y ago
Yes, definitely, we'll be expanding to more regions soon.
8.
by andydb 5y ago
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 so many things that we'd like to do, but we can onl
9.
by andydb 5y ago
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 CockroachDB stack, from the lowest storage l
10.
by andydb 5y ago
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 integrate quite well with that ecosystem, includi
11.
by andydb 5y ago
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 takes some serious operational know-how to keep it running
12.
by andydb 5y ago
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 display information like "# databases in the c
13.
by andydb 5y ago
Great question. We recognize how important this is and are actively working on it.
14.
by andydb 5y ago
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 questions you'd like to ask me about it.
15.
by andydb 8y ago
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 guarantee strict serializability without clocks. But
16.
by andydb 8y ago
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 sequencer. So, yes, FaunaDB is strictly serializable, but at the cos
17.
by andydb 8y ago
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 subject right now, so we'll be following developmen
18.
by andydb 8y ago
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='foo', but only 10 rows have b.
19.
by andydb 8y ago
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 for the benefit of future plans. Another commenter p
20.
by andydb 8y ago
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/master/pkg/sql... Might
21.
by andydb 8y ago
I think you're right; I'm a chess player, and working on the optimizer does hit some of the same neural pathways.
22.
by andydb 8y ago
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 wanted a Go-based optimizer that was more integrated with o
23.
by andydb 8y ago
Yes, that would be clearer language. I'll look into updating the text.
24.
by andydb 8y ago
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 of your optimizer. Also, optimization proceeds top
25.
by andydb 8y ago
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 extra measure of flexibility, power, and elegance to sol
26.
by andydb 8y ago
Yes, that's a real problem that DBAs routinely grapple with. To address the problem, RDBMS vendors typically support hints and "plan management" features that allow DBAs to "pin" a particular plan once they've
27.
by andydb 8y ago
Good question, and something I didn't have the space to cover in this article. The answer involves "physical properties". Physical properties are interesting characteristics of an expression that impact its layout, presentati
28.
How We Built a Cost-Based SQL Optimizer(cockroachlabs.com)
198 points by andydb 8y ago|52 comments
29.
by andydb 8y ago
Not sure I fully understand your question, but I'll try to answer: FaunaDB (like other highly available databases) is set up to have multiple replicas of the same data. You can direct reads to any of the replicas. For example if replic
30.
by andydb 8y ago
Sorry to put you on the spot. Perhaps your CTO can chime in when he gets back. Serializable tends to sound really good to database people, because it's the "highest" isolation level available in most databases. However, those

More ›