178,979 questions
1
vote
0
answers
45
views
System cache constantly grows when stress testing backend app
I've been stress testing my .NET application that uses PostgreSQL to find memory leaks. The app is very stable memory-wise — memory usage only depends on the number of concurrent connections.
However, ...
- 21
Advice
2
votes
2
replies
47
views
Postgres JSON or JSONB to store game's character customization data
I'm building the backend for a platform that works similarly to a game. It includes a simple character customization system with a few properties that aren't particularly relevant to the product (...
- 248
3
votes
1
answer
79
views
create unlogged table automatically on postgres startup or atleast not lose them due to a restart
I tried postgres unlogged table for using them as a cache to speed up queries and it works (50% query time got avoided). I can really recommend that to everyone.
But I restarted the server (I mean the ...
- 65
Best practices
0
votes
7
replies
92
views
Best way to write an Oracle Procedure using Spring Data Jpa
I am new to JPA and learning it. Now I have an Oracle procedure in system, which now needs to be made DB Agnostic, that can run on Postgres. For that I want to write the same functionality of ...
- 503
1
vote
0
answers
74
views
Problem updating Postgres ENUM from DuckDB
I'm on DuckDB 1.4.1 experiencing difficulty updating a Postgres 17.6 ENUM field status:
CREATE TYPE mystatus_enum AS ENUM (
'IN_STOCK', 'OUT_OF_STOCK', 'NOT_FOUND', 'NOT_A_PRODUCT'
);
CREATE ...
- 9,193
-2
votes
0
answers
33
views
Modeling photos and amenities: polymorphic media(entity_id, entity_type) vs separate join tables? [closed]
Context: photos and amenities apply to both properties and units. I want referential integrity + simple deletes.
I'm using PostgreSQL version 17.6.
Option 1: polymorphic media (no FKs across two ...
-2
votes
1
answer
49
views
is it viable and good practice to have a separate staging and production schema in the same DB? [closed]
I am working on a medium sized PostgresSQL (Supabase running in Docker) DB, and my whole env is not that complicated also but it is scaling, working on it in two branches prod and staging
now from ...
-3
votes
0
answers
33
views
Connect to a postgres DB through EF via a SSH connection [closed]
I have a dot net application that needs to connect to a remote Postgres DB through SSH. The app uses EF Core. Any ideas how this can be done ?
- 1,501
1
vote
1
answer
58
views
How to use jsonb functions in hibernate 6?
We use Postgres jsonb_agg function in criteria query API like this:
cb.function(
JSONB_AGG_FUNCTION_NAME,
JsonNode.class,
someJoin.get(someField)
...
- 121
-3
votes
0
answers
48
views
Postgresql critical autovacuum permission denied errors causing server crashes on Windows [closed]
I'm experiencing a critical issue with PostgreSQL 14 on Windows Server 2019 where autovacuum processes consistently crash the entire database server. This is affecting our production environment.
...
- 1
2
votes
2
answers
110
views
Example of partial aggregation
As Postgresql documentation states in # 36.12.4. Partial Aggregation aggregate functions can support partial aggregation.
To do this with custom aggregate function as again the documentation says we ...
- 59
-1
votes
0
answers
42
views
Errors after brew install postgresql@18 in intel mac 13.7.8 [closed]
After I upgraded to Homebrew 4.6.19-6-g4486245 i lost connection to my localhost postgresql@18 db.
I removed postgresql@18 and reinstalled it but I get this error:
FATAL: could not open directory &...
- 139
0
votes
1
answer
53
views
PgCat sometimes routes write queries to replicas
I’m testing a TimescaleDB cluster (1 primary + 2 replicas) behind PgCat, running in Docker Swarm.
Sometimes write queries (CREATE TABLE, INSERT) fail with:
psycopg.errors.ReadOnlySqlTransaction: ...
- 145
0
votes
0
answers
43
views
Java socket connection to GCP Cloud PostgreSQL - Service account authentication
We are trying to connect to the GCP PostgreSQL DB from our Java application using socket connections and service account for authentication.
String dbUser = "[email protected]"...
- 41
0
votes
0
answers
55
views
LATERAL conversion issues when Calcite performs SQL rewrite, NullPointerException
I'm trying to use Calcite+PostgreSQL to rewrite SQL queries, the following error occurs during runtime. How should I solve it?
The main warning is like this：
[warn] call_rewriter failed at idx=1: ...
- 17