Newest Questions
105,495 questions
0
votes
0
answers
6
views
Need to get MDF and LDF file from Studio 3T
I have Azure SQL database connected to Studio 3T.
I am looking for how to get MDF and LDF files.
Any idea how and where to get it ?
Thanks!
0
votes
0
answers
15
views
Choosing winning query based on execution time or bytes_sent
I have two queries that work on the same tables, use the same aggregation but are structured differently. They return the same columns and amount of rows.
However, they both report a different time ...
- 169
0
votes
0
answers
9
views
MariaDB Container create a new Galera cluster node
Is there an official environment variable to bootstrap / create a new Galera cluster node?
I am using the official MariaDB 12.2 image as a Podman service container via a Quadlet which auto-generates a ...
- 101
-2
votes
1
answer
20
views
How to simulate and obtain execution plan in GBase 8s?
Environment:
GBase version: GBase 8s v8.8
OS: RedHat 3.10.0-1160.el7.x86_64
In GBase 8s, is there a method similar to GBase 8a's EXPLAIN keyword to directly obtain a simulated execution plan?
If not, ...
- 1
0
votes
1
answer
24
views
Is there an automatic column2 when using just VALUES() in SQLite?
This works,
ogrinfo -q -al -limit 1 :memory: -dialect SQLite -sql \
"SELECT MakeLine(MakePoint(column1, 90),"\
"MakePoint(column1, -90)) FROM (VALUES (7),(9),(3))"
Layer name: ...
- 101
-1
votes
2
answers
70
views
Future of PostgreSQL DBA: Stay or Switch? [closed]
I currently work as a PostgreSQL DBA, managing production, staging, and development environments. I'm wondering whether PostgreSQL DBA has a strong future, or whether I should consider switching to ...
- 18
-1
votes
0
answers
14
views
How to generate per-group sequence numbers in GBase while avoiding race conditions and contention? [duplicate]
I am working with a GBase database and need to generate a sequential number (serialNo) per group when inserting rows. Each documentType should maintain its own sequence starting from 1.
Example:
...
- 1
0
votes
1
answer
30
views
PITR cold backup or pg_basebackup
If I want to make a copy of a database for point in time (about to make some code changes), and i am sure we can handle to turn off connection and postgres which is better?
Make a cold copy of data ...
- 15
0
votes
0
answers
18
views
How to handle race conditions and locking issues when generating per-group sequences in GBase? [duplicate]
I am working with a GBase database and need to generate a sequential number (serialNo) per group during inserts. Each documentType should maintain its own sequence starting from 1.
Example:
...
- 1
0
votes
0
answers
14
views
How to avoid race conditions and lock contention when generating per-group sequences in GBase? [duplicate]
I am working with a GBase database and need to generate a sequential number (serialNo) per group during inserts. Each documentType should have its own sequence starting from 1.
Example:
documentType | ...
- 1
1
vote
0
answers
22
views
Aggresive table locking on Azure SQL MI
Suddenly out of the blue we've started getting deadlocks on our Azure SQL MI database. WE have ETL processes running (some legacy SSIS and natciev ADF pipelines) almost 24/7 ETL. Our ETLs execute ...
- 13
-3
votes
0
answers
27
views
How to avoid race conditions when generating per-group sequence numbers in GBase? [duplicate]
I am working with a GBase database and need to generate a sequential number (serialNo) per group during inserts. Each documentType should have its own sequence starting from 1.
Example:
documentType | ...
- 1
0
votes
0
answers
14
views
Why does Droppable Tombstone Ratio stay high in Cassandra?
I need some advice about understanding Droppable Tombstone Ratio in Cassandra.
We do not use ALLOW FILTERING in our requests. Cassandra version is 4.1.7.
My archive table had the following settings:
...
- 15
2
votes
1
answer
136
views
Decoding keylock from sys.dm_os_waiting_tasks.resource_description
On SQL Server 2022, I'm investigating blockings, where the sys.dm_os_waiting_tasks.resource_description consistently is as follows, for all blocked queries :
keylock hobtid=72057851424342016 dbid=72 ...
- 127
0
votes
0
answers
15
views
How to avoid duplicates when using logical replication to upgrade PostgreSQL version?
I am planning to in-place upgrade a large (several TB) production database cluster of PostgreSQL 13 to PostgreSQL 18 (Postgres Pro in fact, but shouldn't matter here). The cluster has several replicas,...
- 126