The Wayback Machine - https://web.archive.org/web/20200904060012/https://github.com/cockroachdb/cockroach
Skip to content
master
Go to file
Code

Latest commit

53849: opt: add a per-span cost to scan r=RaduBerinde a=RaduBerinde

This change adds a per-span "random IO" cost for scans. This is more consistent
with how lookup joins are costed. This fixes an issue where we prefer hash join
instead of lookup join even for a single left row when the right table is small,
improving a handful of TPCE queries.

The changes to TPCH Q2 and Q8 seem mildly beneficial from my testing.

Fixes #41701.

Release justification: low risk, high benefit change to existing functionality.

Release note (performance improvement): Joins between very small tables are more
likely to use lookup join.

53936: opt: add missing Copy() in buildInvertedFilterProps r=RaduBerinde a=RaduBerinde

We are modifying `input.OutputCols` in place, which leads to problems
when large ColumnIDs are involved.

Fixes #53933.

Release justification: bug fix for new functionality

Release note: None

Co-authored-by: Radu Berinde <[email protected]>
9fae2ab

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
Sep 3, 2020
pkg
Sep 4, 2020

README.md


CockroachDB is a cloud-native SQL database for building global, scalable cloud services that survive disasters.

What is CockroachDB?

CockroachDB is a distributed SQL database built on a transactional and strongly-consistent key-value store. It scales horizontally; survives disk, machine, rack, and even datacenter failures with minimal latency disruption and no manual intervention; supports strongly-consistent ACID transactions; and provides a familiar SQL API for structuring, manipulating, and querying data.

For more details, see our FAQ or architecture document.

Docs

For guidance on installation, development, deployment, and administration, see our User Documentation.

Quickstart

  1. Install CockroachDB.
  2. Start a local cluster and talk to it via the built-in SQL client.
  3. Learn more about CockroachDB SQL.
  4. Use a PostgreSQL-compatible driver or ORM to build an app with CockroachDB.
  5. Explore core features, such as data replication, automatic rebalancing, and fault tolerance and recovery.

Client Drivers

CockroachDB supports the PostgreSQL wire protocol, so you can use any available PostgreSQL client drivers to connect from various languages.

Deployment

  • Test Deployments - Easiest way to test an insecure, multi-node CockroachDB cluster.
  • Production Deployments
    • Manual - Steps to deploy a CockroachDB cluster manually on multiple machines.
    • Cloud - Guides for deploying CockroachDB on various cloud platforms.
    • Orchestration - Guides for running CockroachDB with popular open-source orchestration systems.

Need Help?

Building from source

See our wiki for more details.

Contributing

We welcome your contributions! If you're looking for issues to work on, try looking at the good first issue list. We do our best to tag issues suitable for new external contributors with that label, so it's a great way to find something you can help with!

See our wiki for more details.

Engineering discussion takes place on our public mailing list, [email protected], and feel free to join our Community Slack (there's a dedicated #contributors channel!) to ask questions, discuss your ideas, or connect with other contributors.

Design

For an in-depth discussion of the CockroachDB architecture, see our Architecture Guide. For the original design motivation, see our design doc.

Comparison with Other Databases

To see how key features of CockroachDB stack up against other databases, check out CockroachDB in Comparison.

See Also

You can’t perform that action at this time.