python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - yugabytedb

Why INSERT query is 3-4 times slower than SELECT?

Application talks to YugabyteDB instance with YCQL driver(Gocql). We have below two queries (for example): SELECT col2, col3, col4, col5 FROM table1 WHERE primarykeycol = 11ab8...
test-img

overexchange

sql

database-performance

sql-execution-plan

explain

yugabytedb

Votes: 0

Answers: 2

Latest Answer

If your RF > 1, insert operations go through a distributed transaction cycle whereby records are stored on a majority of replicas (if RF=3, then 2; if RF=4, then 3, it RF=7, then 5). However, in th...
test-img

dh YB

Checking disk size consumed by each database in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] Is there any way we can check the disk size consumed by each database, tables? I tried the query below but no luck: - \l+ - select pg_database...
test-img

dh YB

yugabytedb

Votes: 0

Answers: 1

Latest Answer

YugabyteDB uses its native data storage called DocDB (i.e. Rocks DB) to store the table's data. These catalog tables will not have any sizing details. You can access individual table level details dir...
test-img

dh YB

Can’t create table in YugabyteDB cluster

[Question posted by a user on YugabyteDB Community Slack] I have a query, I see the log file on the leader is filling with these lines continuously I0110 11:28:47.117158 17899 cluster_balance.cc:1210]...
test-img

dh YB

yugabytedb

Votes: 0

Answers: 1

Latest Answer

The region in your config is us-east-1 but it seems to be looking for us-east in the error. Run this command: ./bin/yb-admin \ --master_addresses 172.151.17.130:7100,172.151.17.220:7100,172.151.17...
test-img

dh YB

Set wal_level = logical instead of replica in YugabyteDB?

[Question posted by a user on YugabyteDB Community Slack] Is there a way to set wal_level = logical instead of replica in YugabyteDB? I’m looking to implement CDC so I can synchronize other systems wi...
test-img

dh YB

yugabytedb

Votes: 0

Answers: 1

Latest Answer

Note that YugabyteDB doesn’t reuse the PostgreSQL storage engine & replication mechanism, but has built its own. And it doesn’t support setting wal_level=logical. Currently, CDC support is in the ...
test-img

dh YB

Posts

Questions

Blogs

Jobs