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.
64 questions
1
vote
1
answer
51
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
61
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
29
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
46
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
58
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
291
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
323
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
113
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
169
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
136
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
237
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,191
0
votes
0
answers
111
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
579
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
0
votes
1
answer
155
views
How to reset stats in "pg_stats_subscription_stats"?
I have some errors produced while making changes to some logically replicated tables. Now I want to reset the errors logged in the pg_stat_subscription_stats table in the apply_error_count column, but ...
- 145