Questions tagged [postgresql-15]
Use this tag to indicate that your question is about PostgreSQL version 15. Questions concerning database administration should go to https://dba.stackexchange.com/
postgresql-15
160
questions
0
votes
0
answers
12
views
Efficient SQL full data retrieval combining JOINs and WHERE
I have a quite complex data model in my current project's database and I am wondering if there is a better/more efficient way of getting all data, after applying some filters, in a single efficient ...
0
votes
0
answers
17
views
PostgreSQL Database PR and DR replication/synchronization
We have a requirement on production environment to run PR and DR as Active/Active. We have four nodes of redhat server. The request will be entertained from both sites means on both sites there should ...
0
votes
0
answers
26
views
UPSERT native SQL query for Collection as @Param of JPA Repository method
I need to iterate over collection of Enteties and apply UPSERT for each element atomically. As i see it - just need to send this collection into SQL query by SpEL.
I know, what i can iterate over ...
0
votes
0
answers
22
views
How can I add a key/value to a sub-object in a postgres jsonb column
I have a table with a jsonb column containing data like:
{
"key_a": "value",
"key_b": {
"_reference": "reference to remote object 1"
...
- 43
1
vote
1
answer
52
views
Do I trust "cost" or "actual time" more when using Postgres EXPLAIN ANALYZE?
I'm trying to improve the performance of one of our most expensive queries. I'm running EXPLAIN ANALYZE on the sandbox postgres 15 database, which has a much smaller dataset than the production ...
0
votes
0
answers
51
views
postgres btree index unique constraint does not work
I have a table accounts_coin with unique constraint on (type, id), but it still have two rows with same value of (type, id), this image shows the problem: click
information might help:
postgres ...
0
votes
0
answers
33
views
Postgresql JSONB column - Index - GIN Vs BTree
I have a large table with multiple partitions (total size = 250 GB). The table has a column with a large json stored as a jsonb column. Users will query using criteria on certain fields (one or ...
0
votes
0
answers
39
views
Installing PLV8 extension for Postgresql under RHEL os
I want to ask if there anyone who installed PostgreSQL 15 with the PLv8 extension on RedHat 9 since I want to make sure if the combination that I am using works just fine, otherwise I might need ...
- 1
0
votes
0
answers
25
views
OSGi application upgrade from Postgres 11/12 to Postgres 15
My OSGi application has been running with a Postgres driver that works Postgres 11 without problems. Oddly, everything has been working so I have had little to deal with the libraries needed. I ...
- 59
1
vote
2
answers
32
views
Skip certain types of nodes in DLL
I'm on Postgres 15.1 and have a node table as follows:
CREATE TABLE node (
id TEXT PRIMARY KEY,
is_skippable BOOL,
prev TEXT REFERENCES node(id),
"next" TEXT REFERENCES node(...
- 117
0
votes
0
answers
17
views
SQLAlchemy One to Many Relationship with Relationship to get Latest Based on Timestamp?
I'm using Python3.11 + SQLAlchemy 2.0.23. I have two models Project and Document. Document has project_id on it and a Project can have multiple Documents.
The issue is that I frequently need to get ...
0
votes
0
answers
46
views
pg_rewind: servers diverged at WAL location
We have a primary and one standby as our HA setup for postgres 15.6. we are using repmgr 5.4.1.1 for our HA setup. We were testing a scenario, if a primary goes down, it is able to do automatic ...
0
votes
0
answers
66
views
#citus Coordinator node setup and worker node setup are not working
I would like to setup citus and use it. But the error occurs like below.
Please take a look at my progress and let me know if I missed anything.
Please refer to the table below for server ...
- 16
0
votes
0
answers
47
views
Does anyone have a default PostgreSQL pg_hba.conf and pg_ident.conf File for postgres version 15?
I've messed my pg_hba.conf file up, and I kinda reinstalled 3 times and i opened the pg_hba.conf for version 15 there was nothing inside. so yeah.
if someone has pg_ident.conf file for postgres ...
0
votes
0
answers
40
views
pg_upgrade failing { pg13.7 -> pg15.6} using pglogical method
I am trying to upgrade PostgreSQL (RHEL 7) from version 13.7 to 15.6 using pglogical.
My Standby(destination) machine has following rpms,
postgresql13-pglogical-3.7.16-1.el7.x86_64
postgresql15-...
- 1