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.
9 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
12
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 ×ばつ longer in the ...
1
vote
1
answer
280
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
221
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: ...
1
vote
0
answers
36
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 ...
0
votes
1
answer
123
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 ...
2
votes
2
answers
284
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'
...
0
votes
0
answers
67
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
194
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 ...
0
votes
1
answer
272
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 ...