Questions tagged [postgresql-17]
Use this tag if your question is about PostgreSQL version 17 specific feature or behaviour. Please also add the generic [postgres] tag.
12 questions
0
votes
2
answers
45
views
Monitoring long-running queries in Aurora PostgreSQL
I'm supporting a new system that's going live next month. I'm trying to have PostgreSQL log any long-running (over 1 second) queries to the error log. I've set the following parameters:
log_duration: ...
- 183
0
votes
1
answer
23
views
Postgres database migration. pg_restore seems to hang
I'm attempting to migrate (users, structures, triggers, data - everything) a postgres 17 database on a windows 10 machine to a new windows 11 server.
The new machine has a default installation of ...
- 1,313
1
vote
1
answer
66
views
Generated column with date and interval
I have read this answer: How to add a generated column with an expression subtracting days? but it throws generation expression is not immutable and i can't get why ?
Here's the table:
CREATE TABLE ...
- 214
0
votes
0
answers
39
views
Query planning time much higher compared to Postgres 14 and TimescaleDB 2.16
We recently upgraded our development environment from Postgres 14 → Postgres 17 and TimescaleDB 2.16 → 2.21.
Since then, we’ve noticed that certain queries involving joins now take 2.5× longer in the ...
1
vote
1
answer
426
views
PostgreSQL logical replication fails with memory allocation error
We have a geographically distributed database setup with seven servers. There are 62 master tables set up for logical replication with six subscribers.
This was working fine for a long time with ...
1
vote
1
answer
333
views
Error "could not reserve shared memory region ... error code 487" on Postgresql 17.5 in Windows
In PG 17.5 on Windows, I'm seeing errors in the log that look like:
2025-06-10 12:53:44.548 EDT [18612] LOG: could not reserve shared memory region (addr=0000022916760000) for child 00000000000014C4: ...
- 375
1
vote
0
answers
40
views
PG 17.5 pg_ctl output not being logged on Windows Server 2019
I'm working on migrating a PG cluster from PG 13.18 to 17.5 on Windows Server 2019
I'm using the community build of PG 17.5 from EDB.
I've completed the migration using pg_upgrade.exe
I've updated the ...
- 375
0
votes
1
answer
183
views
Does the MERGE PARTITION functionality actually exist in PostgresSQL 17?
Is it possible to merge partitions in Postgres 17?
There a a lot of blog posts on the internet suggesting that partition MERGE and SPLIT are (or will be) available in PostgreSQL 17 but there's no ...
- 1,313
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
0
votes
0
answers
80
views
Unable to access Postgress in PgAdmin 4 in windows as it is accessible in terminal wsl
i added screenshot as one is in wsl and one in window terminal as both have same commands but one(WSL) has 8 schemas and the othe one(window) has 6
My project runs on WSL (Windows Subsystem for Linux),...
0
votes
1
answer
215
views
Postgresql 17 take automatic daily incremental backups
Postgresql 17 added a new feature to make incremental backups. I want to use this to make daily incremental backups, however I am struggling to find a good method for automatization, as the build in ...
- 103
0
votes
1
answer
323
views
Postgres updates xmin on every UPDATE within a transaction
If I do an UPDATE to a row within a transaction, each time xmin increments. I thought that xmin always represents the current tx id. But it seems to be storing current xid + cmin instead.
But when ...
