Questions tagged [postgresql-15]
Use this tag if your question is about a PostgreSQL version 15 feature or behaviour. Please also add the generic [postgres] tag.
65 questions
0
votes
0
answers
34
views
PostgreSQL 15: pg_largeobject occupies ~90% of storage due to TEXT columns holding OIDs
On a PostgreSQL 15 server we are facing an issue with storage occupied by pg_largeobject table.
During development, the team migrated an application from Oracle but did not handle PostgreSQL large ...
- 3
1
vote
1
answer
55
views
Is there a limit to the number of values used for a list partition?
We have sensor data used for analytics that has for columns:
CREATE TABLE sensor_data
(
dt date NOT NULL,
timeofday time without time zone NOT NULL,
sensor_id TEXT NOT NULL,
--...
- 615
0
votes
2
answers
63
views
Partitioning on a categorical (low-cardinality) column
Similar to Improving performance with a common low-cardinality field
We get a large dataset and we load it by source. Let's say team_id. We currently have our data partitioned by team_id and then by ...
- 615
1
vote
0
answers
31
views
Suggestion regarding Migrating and Sharding 1TB standalone PostgreSQL Cluster with Partitions and Multiple Databases, using Citus
We're currently in the evaluation/planning phase evaluating Citus (open-source) as a sharding solution (multi tenant) for our existing PostgreSQL database cluster. We anticipate significant data ...
- 11
0
votes
1
answer
50
views
Why does PostgreSQL not check permissions of the table referencing (with ON DELETE CASCADE) a table being deleted from?
On PostgreSQL 15, I have the following objects:
appuser_locked table is referencing appuser table with ON DELETE CASCADE. application_role is granted DELETE on appuser table but not on appuser_locked ...
- 293
2
votes
0
answers
60
views
Deadlock seems to occasionally and regularly lead to replication failure
We have two PostgreSQL databases running on RHEL virtual servers (PostgreSQL 15.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit). Our production server/...
- 615
1
vote
1
answer
314
views
PostgreSQL 15 Restore Failing Due to Incorrect UUID Handling in Dump
I'm facing an issue while restoring a PostgreSQL 15 database dump. During the restore process, I encounter the following errors:
ERROR: trailing junk after numeric literal at or near "..."
...
- 11
2
votes
2
answers
351
views
(non-breaking space) is not considered whitespace by Postgres?
String-functions in Postgres do not recognize non-breaking-space as whitespace, neither when trimming nor when using regular expressions:
select 'x' || test || 'x'
, 'x' || trim(test) || 'x'
...
- 123
1
vote
1
answer
118
views
Replay lag on replica even after setting max_standby_streaming_delay
I've a 1 master and 5 replicas postgresql cluster configured as hot standby using streaming replication in synchronous mode.
I've started to see 10' replay delays in one of the sync replicas while ...
Nico Gatti
0
votes
1
answer
178
views
My postgres database startup has been running for almost 2 days+
I messed up my pgsql database by mistakenly deleting files on pg_wal, it resulted to a non-recoverable state (with no backups to restore with) so i decided to run the pg_resetwal.exe -f (considering ...
- 1
0
votes
0
answers
145
views
pgAudit Install Not Working Because of Makefile (Postgres 15)
Hi My Makefile supposedly doesnt have an install target. How do I fix this?
I dont understand how it even worked for others. Also, I cant use an updated version of Postgres due to restrictions at my ...
- 1
0
votes
1
answer
1k
views
Could not Access File $libdir/vector No Such File or Directory
I am not a DBA. I am trying to test and experiment.
I am on a Windows 11 machine and using PgAdmin. I have PostgreSQL 15 installed.
When I run CREATE EXTENSION VECTOR, I get the following error ...
0
votes
0
answers
244
views
How to set up Postgresql pglogical replication on the same database instance
I am trying to assess pglogical replication usage instead of the built-in one (particularly due to being able to filter by operation). I am using a single Azure Postgresql flexible server database ...
- 1,193
0
votes
0
answers
113
views
Unable to execute psql with postgres user
After a server failure I'm not able to execute psql like psql -U postgres nor like sudo -u postgres psql. In both cases I'm asked for the user password despite I've modified the pg_hba.conf files to ...
3
votes
1
answer
615
views
UNNEST vs ANY()
When selecting a number of records from a Postgres table based on a list of ids passed as a parameter, what are the benefits and drawbacks of
SELECT id, <more...>
FROM tbl
INNER JOIN UNNEST($1) ...
- 133