# Latest **URL:** https://forum.cockroachlabs.com/latest.md?page=1 [Latest](https://forum.cockroachlabs.com/latest.md) · [Categories](https://forum.cockroachlabs.com/categories.md) · [Tags](https://forum.cockroachlabs.com/tags.md) **Page:** 2 --- ## [Question about sql TYPEs](https://forum.cockroachlabs.com/t/question-about-sql-types/6947)
**Author:** [@gonedaddy1](https://forum.cockroachlabs.com/u/gonedaddy1)\ **Replies:** 3\ **Last updated:** [December 16, 2024, 2:45pm UTC](https://forum.cockroachlabs.com/t/question-about-sql-types/6947 "2024-12-16T14:45:11Z")
We have a couple of different people designing tables and their own data dictionary. So one guy defines CITY as STRING(50) and another guy defines it as STRING(64) and someone else made CITY to be a STRING(100). I don’t… --- ## [Performance degradation over time](https://forum.cockroachlabs.com/t/performance-degradation-over-time/6946)
**Author:** [@tk35c](https://forum.cockroachlabs.com/u/tk35c)\ **Replies:** 1\ **Last updated:** [December 9, 2024, 10:26am UTC](https://forum.cockroachlabs.com/t/performance-degradation-over-time/6946 "2024-12-09T10:26:48Z")
Hello. I’m testing Cockroach v24.3 in a 6 nodes cluster and I’m experiencing quite some performance degradation over time. The full description for the problem is in Performance degradation with batch upserts on v24.2.… --- ## [Cluster 3 nodes use 12GB+ memory without any data](https://forum.cockroachlabs.com/t/cluster-3-nodes-use-12gb-memory-without-any-data/6945)
**Author:** [@kocoten1992](https://forum.cockroachlabs.com/u/kocoten1992)\ **Replies:** 1\ **Last updated:** [December 9, 2024, 10:25am UTC](https://forum.cockroachlabs.com/t/cluster-3-nodes-use-12gb-memory-without-any-data/6945 "2024-12-09T10:25:38Z")
Hello, I’m trying cockroachdb, I set up a secure cluster 3 nodes using v24.3.0 (each node have 16GB), the cluster doesn’t have any data in it (to be absolutely correct - less than 10kb), it just there so I could try deve… --- ## [Could Someone Give me Advice for Optimizing CockroachDB Performance in High-Throughput Applications?](https://forum.cockroachlabs.com/t/could-someone-give-me-advice-for-optimizing-cockroachdb-performance-in-high-throughput-applications/6164)
**Author:** [@Padrickk](https://forum.cockroachlabs.com/u/Padrickk)\ **Replies:** 3\ **Last updated:** [December 9, 2024, 10:08am UTC](https://forum.cockroachlabs.com/t/could-someone-give-me-advice-for-optimizing-cockroachdb-performance-in-high-throughput-applications/6164 "2024-12-09T10:08:00Z")
Hello there, I am working on a project where we are using CockroachDB as our primary database for a high through put application. We are experiencing some performance challenges and I am reaching out to the community to… --- ## [Transaction isolation levels: which statement is true?](https://forum.cockroachlabs.com/t/transaction-isolation-levels-which-statement-is-true/6944)
**Author:** [@tk35c](https://forum.cockroachlabs.com/u/tk35c)\ **Replies:** 4\ **Last updated:** [December 3, 2024, 8:00am UTC](https://forum.cockroachlabs.com/t/transaction-isolation-levels-which-statement-is-true/6944 "2024-12-03T08:00:23Z")
Hello. In your documentation is stated that, by default, CockroachDB runs in SERIALIZABLE mode as shown in but, in READ COMMITTED section it’s stated that by default READ COMMITTED mode is enabled, as shown in an… --- ## [Help to understand the metrics](https://forum.cockroachlabs.com/t/help-to-understand-the-metrics/6942)
**Author:** [@tk35c](https://forum.cockroachlabs.com/u/tk35c)\ **Replies:** 4\ **Last updated:** [November 28, 2024, 12:28pm UTC](https://forum.cockroachlabs.com/t/help-to-understand-the-metrics/6942 "2024-11-28T12:28:41Z")
Hello. In my company I’m currently evaluating CockroachDB and I need some clarifications about the metrics shown in the UI. In particular, the number of writes shown in the picture below: My test application is a S… --- ## [List all nodes in subjectaltname of certificate?](https://forum.cockroachlabs.com/t/list-all-nodes-in-subjectaltname-of-certificate/6938)
**Author:** [@gonedaddy1](https://forum.cockroachlabs.com/u/gonedaddy1)\ **Replies:** 1\ **Last updated:** [November 25, 2024, 7:10pm UTC](https://forum.cockroachlabs.com/t/list-all-nodes-in-subjectaltname-of-certificate/6938 "2024-11-25T19:10:30Z")
Doing a new install of 24.3.0-rc1 on-prem with 3 nodes and using OpenSSL for certificate creation. When creating the node certs, can I include all the node names (db1, db2, db3) as DNS: entries on the subjectaltname lin… --- ## [Getting issue in Cockroach DB cluster](https://forum.cockroachlabs.com/t/getting-issue-in-cockroach-db-cluster/6152)
**Author:** [@Sagarbud](https://forum.cockroachlabs.com/u/Sagarbud)\ **Replies:** 1\ **Last updated:** [October 28, 2024, 3:08pm UTC](https://forum.cockroachlabs.com/t/getting-issue-in-cockroach-db-cluster/6152 "2024-10-28T15:08:58Z")
Hello All, We have setup three node Cockroach-DB cluster(version: 22.2.14) on GKE kubernetes cluster on GCP using Helm. Helm chart version is 6.0.3. Suddenly, we’re getting below error on Cockroach-DB pod’s. Also, Cockr… --- ## [Creation of cluster](https://forum.cockroachlabs.com/t/creation-of-cluster/5886)
**Author:** [@Jayesh\_Ashok\_Jain](https://forum.cockroachlabs.com/u/Jayesh_Ashok_Jain)\ **Replies:** 1\ **Last updated:** [October 7, 2024, 9:33pm UTC](https://forum.cockroachlabs.com/t/creation-of-cluster/5886 "2024-10-07T21:33:39Z")
Hello Team, I am trying to install 2 nodes cluster for cockroach. Followed the steps and created the certs on node1 wth following steps : Node 1 : cockroach cert create-ca --certs-dir=/opt/cockroachdb/certs --ca-key=… --- ## [Secure CockroachDB Deployment using Certificates issued by Public CA](https://forum.cockroachlabs.com/t/secure-cockroachdb-deployment-using-certificates-issued-by-public-ca/6128)
**Author:** [@Nambi](https://forum.cockroachlabs.com/u/Nambi)\ **Replies:** 1\ **Last updated:** [October 7, 2024, 6:51pm UTC](https://forum.cockroachlabs.com/t/secure-cockroachdb-deployment-using-certificates-issued-by-public-ca/6128 "2024-10-07T18:51:48Z")
Hi Team, I have started and initialized a 3 node crdb cluster using the Node and Client Certificates issued by a Public CA. All went well. Now that I have create a user to login to the DB Console, I have launched the bu… --- ## [How does cockroachdb count vCPUs?](https://forum.cockroachlabs.com/t/how-does-cockroachdb-count-vcpus/6171)
**Author:** [@Colm](https://forum.cockroachlabs.com/u/Colm)\ **Replies:** 2\ **Last updated:** [October 2, 2024, 7:10pm UTC](https://forum.cockroachlabs.com/t/how-does-cockroachdb-count-vcpus/6171 "2024-10-02T19:10:06Z")
On the console overview page, there is a list of Nodes that shows a count of vCPUs per each node. The manual describes this number as “Number of vCPUs on the machine.”: What exactly does the “machine” refer to here? W… --- ## [Why my post has been Hidden?](https://forum.cockroachlabs.com/t/why-my-post-has-been-hidden/6168)
**Author:** [@Padrickk](https://forum.cockroachlabs.com/u/Padrickk)\ **Replies:** 2\ **Last updated:** [September 27, 2024, 8:52pm UTC](https://forum.cockroachlabs.com/t/why-my-post-has-been-hidden/6168 "2024-09-27T20:52:37Z")
Hello there, Recently I posted a query on this website- Why my post has been hidden? - SST Guide Forums After few minutes, I got a notification that left me disappointed as it shows my content is Hidden. I don’t kno… --- ## [Cockroach db database with single node](https://forum.cockroachlabs.com/t/cockroach-db-database-with-single-node/6162)
**Author:** [@vishalzuru](https://forum.cockroachlabs.com/u/vishalzuru)\ **Replies:** 3\ **Last updated:** [August 29, 2024, 12:49pm UTC](https://forum.cockroachlabs.com/t/cockroach-db-database-with-single-node/6162 "2024-08-29T12:49:42Z")
We have cockroach db databases running in three environments: development, stage, and production. We have deployed the cockroach database on AWS EC2 virtual machines. We have three virtual machines running in stage and p… --- ## [How to speed up inserts](https://forum.cockroachlabs.com/t/how-to-speed-up-inserts/6160)
**Author:** [@AlexCologne](https://forum.cockroachlabs.com/u/AlexCologne)\ **Replies:** 1\ **Last updated:** [August 26, 2024, 6:47pm UTC](https://forum.cockroachlabs.com/t/how-to-speed-up-inserts/6160 "2024-08-26T18:47:32Z")
I have a cockroach db with 3 nodes and the following table structure: CREATE TABLE public.urls ( id INT8 NOT NULL GENERATED ALWAYS AS IDENTITY, url VARCHAR NULL, CONSTRAINT urls\_pk PRIMARY KEY (id ASC), UNIQUE I… --- ## [Cockroach db vm auto scaling AWS](https://forum.cockroachlabs.com/t/cockroach-db-vm-auto-scaling-aws/6157)
**Author:** [@vishalzuru](https://forum.cockroachlabs.com/u/vishalzuru)\ **Replies:** 3\ **Last updated:** [August 21, 2024, 4:24pm UTC](https://forum.cockroachlabs.com/t/cockroach-db-vm-auto-scaling-aws/6157 "2024-08-21T16:24:59Z")
I set up the cockroach database on an Amazon Web Services virtual machine. I created three m6i.large virtual machines with two CPUs and eight gigabytes of RAM per node. Cockroach database performs admirably on the nodes.… --- ## [How to use cockroach demo in a docker container?](https://forum.cockroachlabs.com/t/how-to-use-cockroach-demo-in-a-docker-container/6156)
**Author:** [@sean\_phoenix](https://forum.cockroachlabs.com/u/sean_phoenix)\ **Replies:** 1\ **Last updated:** [July 31, 2024, 1:48pm UTC](https://forum.cockroachlabs.com/t/how-to-use-cockroach-demo-in-a-docker-container/6156 "2024-07-31T13:48:25Z")
I’m trying to use some enterprise features in a CI pipeline, so going with cockroach demo, which runs within a docker container, but having trouble connecting to it. Even trying to replicate on my local machine (still u… --- ## [Cockroach Support](https://forum.cockroachlabs.com/t/cockroach-support/6155)
**Author:** [@sean\_phoenix](https://forum.cockroachlabs.com/u/sean_phoenix)\ **Replies:** 2\ **Last updated:** [July 19, 2024, 9:29pm UTC](https://forum.cockroachlabs.com/t/cockroach-support/6155 "2024-07-19T21:29:25Z")
Your support links are down Join the CockroachDB Slack community | Cockroach Labs Are there no higher level support tiers? How do I have cockroach dedicated, declare an incident in production, and it marks it as P4 low … --- ## [Is a table with 5 billion records be feasible in cockroachDB?](https://forum.cockroachlabs.com/t/is-a-table-with-5-billion-records-be-feasible-in-cockroachdb/6154)
**Author:** [@mishranitin2003](https://forum.cockroachlabs.com/u/mishranitin2003)\ **Replies:** 1\ **Last updated:** [July 15, 2024, 9:20pm UTC](https://forum.cockroachlabs.com/t/is-a-table-with-5-billion-records-be-feasible-in-cockroachdb/6154 "2024-07-15T21:20:16Z")
I have a table to contain around 5 billion records. Below is a structure of table: id INT8 PRIMARY KEY, col1 INT8 NOT NULL, col2 INT8 NOT NULL, col3 STRING NULL, col4 STRING NULL, col5 INT8 NULL, col6 JSONB NULL, … --- ## [Potential Memory Leak v23.2](https://forum.cockroachlabs.com/t/potential-memory-leak-v23-2/6103)
**Author:** [@Aris](https://forum.cockroachlabs.com/u/Aris)\ **Replies:** 16\ **Last updated:** [July 1, 2024, 12:00pm UTC](https://forum.cockroachlabs.com/t/potential-memory-leak-v23-2/6103 "2024-07-01T12:00:08Z")
Hello, We have been running a small Cockroach cluster v22.1 for a couple of years now without any issues whatsoever. However, recently we upgraded the cluster to version 23.2.0 and immediately started noticing a slow bu… --- ## [Migration from PostgreSQL managed by peewee](https://forum.cockroachlabs.com/t/migration-from-postgresql-managed-by-peewee/6148)
**Author:** [@0xC4DE](https://forum.cockroachlabs.com/u/0xC4DE)\ **Replies:** 4\ **Last updated:** [June 28, 2024, 9:20pm UTC](https://forum.cockroachlabs.com/t/migration-from-postgresql-managed-by-peewee/6148 "2024-06-28T21:20:43Z")
Hello. I’m currently migrating a data base from MySQL → Postgresql → Cockroach (locally hosted). The reason for the intermediary step is because we wish to support both Postgres & Cockroach, managed by Peewee ORM, using … --- ## [Iterate resultset in cursor](https://forum.cockroachlabs.com/t/iterate-resultset-in-cursor/6142)
**Author:** [@Kapase](https://forum.cockroachlabs.com/u/Kapase)\ **Replies:** 1\ **Last updated:** [June 25, 2024, 3:13pm UTC](https://forum.cockroachlabs.com/t/iterate-resultset-in-cursor/6142 "2024-06-25T15:13:59Z")
I have created store procedure, inside store procedure I want to iterate result of query. is it possible? I tried using cursor but getting error at line of fetch… CREATE OR REPLACE PROCEDURE test\_cursor() AS $$ DECLA… --- ## [Crdb\_region based on Foreign key](https://forum.cockroachlabs.com/t/crdb-region-based-on-foreign-key/6140)
**Author:** [@kaiyoto](https://forum.cockroachlabs.com/u/kaiyoto)\ **Replies:** 1\ **Last updated:** [June 24, 2024, 2:56pm UTC](https://forum.cockroachlabs.com/t/crdb-region-based-on-foreign-key/6140 "2024-06-24T14:56:50Z")
Is it possible to have crdb\_region be determined based on a foreign key? For example: Users Id | Name | crdb\_region 1 | Joe | USA 2 | Doe | Europe Posts Id | User\_Id | Content 1 | 1 | Hello 2 | 1 | Hi! 3 | 1 | M… --- ## [CDC to Google Pub/Sub - Message Attributes](https://forum.cockroachlabs.com/t/cdc-to-google-pub-sub-message-attributes/6138)
**Author:** [@CBOS](https://forum.cockroachlabs.com/u/CBOS)\ **Replies:** 2\ **Last updated:** [June 17, 2024, 9:34pm UTC](https://forum.cockroachlabs.com/t/cdc-to-google-pub-sub-message-attributes/6138 "2024-06-17T21:34:55Z")
Hello - I’m experimenting with implementing a CDC stream to Google Pub/Sub. Is it possible to configure the message that gets sent to the topic, specifically, the attributes parameter? This can be used in Pub/Sub to filt… --- ## [SQL Activity page not showing all slow queries](https://forum.cockroachlabs.com/t/sql-activity-page-not-showing-all-slow-queries/6134)
**Author:** [@Colm](https://forum.cockroachlabs.com/u/Colm)\ **Replies:** 3\ **Last updated:** [June 17, 2024, 9:47am UTC](https://forum.cockroachlabs.com/t/sql-activity-page-not-showing-all-slow-queries/6134 "2024-06-17T09:47:40Z")
Hi My console is showing strange behaviour on the SQL Activity page. The first image below shows a 5 minute time window, and the slowest query is 75.2s. The next image shows a 24hr window on the same day, but the 75.2s … --- ## [Full scan for min/max in group by with index](https://forum.cockroachlabs.com/t/full-scan-for-min-max-in-group-by-with-index/6118)
**Author:** [@barsv](https://forum.cockroachlabs.com/u/barsv)\ **Replies:** 5\ **Last updated:** [May 15, 2024, 2:29pm UTC](https://forum.cockroachlabs.com/t/full-scan-for-min-max-in-group-by-with-index/6118 "2024-05-15T14:29:30Z")
Hi, I have the following SQL: -- create a table with 2 columns drop table if exists t; create table t (a int, b int); -- insert 1 000 000 rows to have some data INSERT INTO t (a, b) SELECT x % 100, (x % 100) \* 10 + (x … --- ## [Multi-cluster deployment using Istio](https://forum.cockroachlabs.com/t/multi-cluster-deployment-using-istio/4056)
**Author:** [@pup\_seba](https://forum.cockroachlabs.com/u/pup_seba)\ **Replies:** 1\ **Last updated:** [May 6, 2024, 5:42pm UTC](https://forum.cockroachlabs.com/t/multi-cluster-deployment-using-istio/4056 "2024-05-06T17:42:30Z")
Hi, Is there any guide on how to deploy multicluster using Istio? Istio is already in place between 2 clusters and replicated control planes are working as expected. Idea would be to have 2 statefulsets (one on each clu… --- ## [Release notes for v23.1.19](https://forum.cockroachlabs.com/t/release-notes-for-v23-1-19/6112)
**Author:** [@shannonb](https://forum.cockroachlabs.com/u/shannonb)\ **Replies:** 0\ **Last updated:** [April 18, 2024, 9:09pm UTC](https://forum.cockroachlabs.com/t/release-notes-for-v23-1-19/6112 "2024-04-18T21:09:25Z")
CockroachDB v23.1.19 is now available. Please see the release notes for details. --- ## [Release notes for v24.1.0-beta.1](https://forum.cockroachlabs.com/t/release-notes-for-v24-1-0-beta-1/6111)
**Author:** [@shannonb](https://forum.cockroachlabs.com/u/shannonb)\ **Replies:** 0\ **Last updated:** [April 17, 2024, 8:10pm UTC](https://forum.cockroachlabs.com/t/release-notes-for-v24-1-0-beta-1/6111 "2024-04-17T20:10:11Z")
CockroachDB v24.1.0-beta.1 is now available. Please see the release notes for details. --- ## [Release notes for v23.1.18](https://forum.cockroachlabs.com/t/release-notes-for-v23-1-18/6110)
**Author:** [@shannonb](https://forum.cockroachlabs.com/u/shannonb)\ **Replies:** 0\ **Last updated:** [April 12, 2024, 1:14pm UTC](https://forum.cockroachlabs.com/t/release-notes-for-v23-1-18/6110 "2024-04-12T13:14:10Z")
CockroachDB v23.1.18 is now available. Please see the release notes for details! --- ## [Cluster and nodes](https://forum.cockroachlabs.com/t/cluster-and-nodes/6106)
**Author:** [@sansknowledge](https://forum.cockroachlabs.com/u/sansknowledge)\ **Replies:** 1\ **Last updated:** [April 8, 2024, 10:28pm UTC](https://forum.cockroachlabs.com/t/cluster-and-nodes/6106 "2024-04-08T22:28:15Z")
Hi, I am very fresh to cockroachdb. I am having a windows network system with multiple system. on two systems of windows 10 os and windows server 2019 with different ip address and pingable and telnet enabled. both the … [Previous page](https://forum.cockroachlabs.com/latest.md) [Next page](https://forum.cockroachlabs.com/latest.md?page=2)