178,992 questions
0
votes
0
answers
5
views
Why does PostgreSQL prefer hash join when using explicit JOIN instead of a subquery?
I'm working with PostgreSQL and noticed an interesting behavior regarding join strategies.
I have a table requests that references templates. I want to select all requests whose template is of type 1.
...
0
votes
0
answers
48
views
writing changes to two databases during Oracle to Postgres migration [closed]
I am using Oracle for production, and need to migrate to Postgres with no downtime. I figured out that I can follow the 4-step? approach for the migration.
First, write changes to both databases, and ...
0
votes
0
answers
36
views
Entity Framework Core (9.0.9) is not respecting my entity configurations
Problem: I have an ASP.NET Core 9 Web API project and I'm using EntityFrameworkCore 9.0.9 to access a Postgres database.
I try to configure a derived entity to map a database table, but it just doesn'...
- 1
3
votes
1
answer
74
views
Find existing roles without being able to connect to local Postgres cluster
I have a Postgres data directory, which I have mounted in Docker. The database started without errors. However, this database does not contain a postgres role and I forgot which roles I had set up!
So,...
- 33
0
votes
0
answers
16
views
Patroni stuck in "restarting" state indefinitely - only updating leader lock, not actually starting PostgreSQL [closed]
Problem:
My Patroni node (postgresql0) has been stuck in "restarting" state for over an hour. PostgreSQL is properly shut down, but Patroni is not attempting to start it - it's just ...
- 13
1
vote
2
answers
59
views
Sql injection protection when sending json as a sql function parameter
I am sending a json array with filter parameters from ExtJs in the sql function parameter.
filters look like this:
[{"field":"product_type_id","data":{"type":&...
- 13
-3
votes
0
answers
40
views
Edit a Postgres table with a primary key in pgAdmin [closed]
I can't edit one of my tables by double-clicking values in the Data Grid. Looks like it's because I have no primary key for this table.
Is there a method to avoid primary key adding, just to make some ...
- 1
1
vote
0
answers
29
views
Postgresql slow query because of JIT [migrated]
We found a simple query which is much slower using the JIT Compilation. The Query Plan
kicktipp=# show jit;
jit
-----
on
(1 row)
kicktipp=# explain analyze select * from tippereignis where ...
- 41
0
votes
0
answers
13
views
Postgres Temp table performance [migrated]
We are converting a database from SQL Server 2022 to Postgres 18.
Our system has a lot of code in the database and a lot of queries that use local temp tables a lot more than CTE's. This is due to the ...
- 43
0
votes
0
answers
27
views
AWS DMS Keeps silently failing with resource temporarily unavailable (apr status = 11)
I'm using AWS DMS to migrate from PostgreSQL 9.6 to PostgreSQL 17.5 and the DMS task keeps failing on a single table with this error
atfo_read: status__ == APR_SUCCESS failed (at_file.c:1000)
...
- 361
0
votes
0
answers
16
views
node-pg pool setup in a server vs serverless lambda
so we currently have a serverless in which we use like 3 endpoint.. all of them are very important.
and a nestjs server
we were using raw connections from pg-node till now and just switched to using ...
1
vote
1
answer
81
views
Copy parts of different PostgreSQL tables to a single file and restore them
Let’s say I have two different schemas with 2 tables each:
schema_one with tables this, that
schema_two with tables here, there
The tables have the following structure:
schema_one.this:
id
...
0
votes
1
answer
66
views
Why does the same query breaks when upgrading from postgre 14.17 to 14.19 when using timestamp?
After our provider upgraded our pg-14 database from 14.17 to 14.19, with timescaledb extension 2.5.2, our app completely broke because of awful database performances.
Our analysis showed that the ...
- 2,479
1
vote
1
answer
86
views
C# NET Core LINQ To Entities doubling subquery for sorting
I am working with EF Core 6.0 Web APi.
Npgsql.EntityFrameworkCore.PostgreSQL 6.0.29
PostgreSQL 16.3
I have database (Postgres) with musical entities and lessons. Lessons related to musical entities by ...
0
votes
0
answers
44
views
Efficient way to handle transactional consistency across asynchronous operations in Play Framework (Java + Ebean) [closed]
I’ve tried wrapping the logic in a Play @Transactional annotation and also explored using DB.execute() and DB.executeAsync(), but since the external call is non-blocking, the transaction may still be ...
