Newest Questions
105,132 questions
0
votes
0
answers
4
views
On Sybase ASE 16, why is a simple query using a prepared statement 37 % slower than an equivalent stored procedure?
I am using Sybase Adaptive Server Enterprise (ASE) 16. I am using jConnect 4 in version 7.07.
I have a stored procedure that contains a rather simple query, equivalent to this one (I have changed the ...
- 101
3
votes
1
answer
19
views
Do I need to run sp_refreshview and sp_refreshsqlmodule after changing column collations?
I look after the database for a vendor’s application that our system team uses to store passwords. This database is part of a three-node AlwaysOn Availability Group. The instance and database ...
- 31
0
votes
0
answers
8
views
Using Group Managed Service Account to login to SQL Server 2022
Help please!
I have a manual install of SQL 2022 built with the service running as the built in account. I now want to change the service to run as the group managed service account that I now have (i....
- 427
0
votes
1
answer
14
views
VACUUM stuck on vacuuming indexes for days on a 2.4 TB table PostgreSQL 15
In PostgreSQL 15, there is a large non-partitioned table (~2.4 TB) where VACUUM has stopped completing in an acceptable time and has been stuck in the vacuuming indexes phase for 4 days.
...
- 11
0
votes
0
answers
8
views
Is it safe to use RTLD_NODELETE to prevent Teradata from unloading UDF shared libraries on failure?
I'm working on a UDF solution for the Teradata Database. My UDFs are written in C and compiled into a .so (shared object) library, which I reference during CREATE FUNCTION.
I'm running these UDFs in ...
- 1
0
votes
2
answers
18
views
psql: Correct way to index a small column when used with other columns
When implementing soft delete on a table that can be searched by other columns, which is the correct way to index it?
Let's say the table has an id field, and a couple of text fields, and finally a ...
- 101
1
vote
1
answer
34
views
Null value does not violate FOREIGN KEY constraint?
I am wondering why Postgres allows to insert a non-existing values for a foreign key to a nullable multicolumn unique constraint. (Cannot be an actual primary key.)
I made a fiddle. I expected this to ...
- 113
2
votes
1
answer
85
views
Primary Key creation for duplicate tables living on separate machines, in Postgres
I'm building out a data warehouse system in PostgreSQL that will be replicated across several machines. Each machine will read and write to its respective database, independent of the other machines ...
- 131
1
vote
1
answer
41
views
How to speed up bulk insert with deduplication using ON CONFLICT DO NOTHING in PostgreSQL?
I’m working with PostgreSQL 15 and need to move rows from TableA into TableB_dedup. TableB_dedup has a primary key that should "eat" duplicate rows — effectively performing deduplication ...
- 11
0
votes
1
answer
26
views
How does Postgresql autovacuum determine which tables it needs to vacuum and/or analyze?
When the autovacuum daemon kicks off, how does it choose which tables to vacuum? My guess is it runs a query, perhaps like this one which appears to be used by Amazon RDS. I suspect that postgres ...
- 375
0
votes
2
answers
62
views
How to implement redundant databases with mutual synchronization in PostgreSQL or SQL Server
I am writing a program in Golang where I need to set up redundant databases. Here’s the requirement:
I have two databases that act as redundant to each other.
The application first tries to write data ...
0
votes
1
answer
26
views
What happens in MariaDB if an index is dropped from a table while a join is running on that table?
I am running Fedora 42 KDE spin, and the output from mysql -V is
mysql Ver 15.1 Distrib 10.11.11-MariaDB, for Linux (x86_64) using
EditLine wrapper
I have a script that runs weekly that creates a ...
- 161
0
votes
0
answers
22
views
Location Hierarchy representing production rooms or first-class entity?
I'm struggling to figure out the best way to model Production Rooms in our manufacturing ERP app. Currently, we have a Locations model which is a hierarchical, materialized-path (Ancestry Gem) ...
- 103
1
vote
0
answers
3
views
How to get snapshotConflictHorizon transactionID in postgres standby without seeing pg_wal files?
When ever master node performs vacuum, he also logs the snapshotConflictHorizon for few specific vacuum records
for example
rmgr: Heap2 len (rec/tot): 64/ 64, tx: 0, lsn: 1/...
- 137
1
vote
0
answers
7
views
How to export MongoDB Atlas cluster usage metrics?
I’m using MongoDB Atlas and would like to track my cluster usage metrics (read, write, connections, etc.). In the Atlas dashboard, you can see these metrics in charts like this:
Is there a way to ...
bebel