Questions tagged [postgresql-13]
Specifically for PostgreSQL version 13
152 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
2
answers
101
views
What will be the root cause for the incident?
I’m facing a strange issue with PostgreSQL query performance. The same query runs in under 1 second during certain periods, but takes around 20 seconds at other times. However, the data volume and ...
1
vote
1
answer
112
views
PostgreSQL 13 on Windows – "invalid page in block 0 of relation pg_index" – How to recover?
I'm facing a serious issue with my PostgreSQL 13 instance on Windows. I'm unable to open a database in pgAdmin and receive the following error:
ERROR: invalid page in block 0 of relation base/16394/...
1
vote
1
answer
57
views
Postgres Database Free Storage Space Downward
I have a situation on my Postgres 13 db on AWS.
8TB of storage
60GB of memory that it isn't really using
I regularly check to see if any query is running and if so, kill it.
Transaction Log Disk ...
0
votes
0
answers
51
views
Why can a SELECT query produce a "permission denied for schema X" error when permission IS granted for that schema?
I have spent a couple hours digging into documentation, online blogs, and the particular permission settings for this DB. My best lead is https://stackoverflow.com/a/28503453/5419599 (more on that ...
2
votes
1
answer
75
views
PG 13 write performance deteriorates after OS Upgrade Win Server 2012r2 to 2019 with LWLock WALWrite statuses
I've upgraded the OS on PG database server from Win Server 2012r2 Standard to 2019 Standard. Nothing else was changed. Now I see write throughput deteriorates greatly during peak update times with ...
2
votes
2
answers
148
views
PostgreSQL: Finding last executed statement from an "idle in transaction timeout"
Is there any way to log or find last executed statement from a session that terminated because of idle in transaction timeout? We only have slow statement logging and that did not capture it and we ...
2
votes
0
answers
42
views
PostgreSQL: How much memory should I allocate as ramdisk for "pg_stat_tmp"?
We have been facing a problem in an Azure VM running PostgreSQL13 where a recurring issue of disk availability causing statistics collector process to stall for few seconds followed by slow queries. ...
1
vote
1
answer
143
views
Replay standby WAL to point in time without creating new timeline
We have a PostgreSQL 13 replication cluster where one of the standbys is setup with a recovery_min_apply_delay="x hr", which could be useful in the case of data corruption.
For a scenario ...
0
votes
1
answer
82
views
Cannot import a database dump on Postgres 13.14+ while it loads fine in Postgres 13.13
I'm experiencing a problem with loading a PostgreSQL backup file (SQL format).
The SQL file has a function that is defined after another function where it's used. PostgreSQL 13.13 can handle such a ...
0
votes
0
answers
20
views
postgreSQL server 13.13 version , setting the log_statement (none,ddl,mod) parameter not effect the log file outputs
We are using postgreSQL server 13.13 version , setting the log_statement (none,ddl,mod,all) parameter does not effect the log file output.
Setting log_statement = none and restart server
Upgrading ...
0
votes
0
answers
46
views
Temporary relation files not removed after sessions ends - Single PostgreSQL instance PostgreSQL 13
We are facing default temporary tablespace disk space full issue due to lots of below temporary relations files created but not removed after ending session
1.1G t756_1536213694.409
1.1G ...
1
vote
0
answers
103
views
Why is the replication delay in pgpool showing a very large number?
To calculate replication delay in pgpool, the value is obtained from the view pg_stat_replication.replay_lag.
However, sometimes when executing show pool_nodes, it displays a significantly larger ...
0
votes
1
answer
398
views
Does long running query cause replication delay in PostgreSQL which is in 'idle in transaction' state?
In my system I found same query called more than 30 times 'idle in transaction' state. Is there any way to to identify the reason of 'idle in transaction'? Should I terminate those query manually ...
0
votes
1
answer
213
views
Why is restored database faster than original?
I ran this explain analyse in my PostgreSQL 13.7 database:
explain(analyze, verbose, buffers, settings) select * from main_table;
Seq Scan on public.main_table (cost=0.00..10246.15 rows=220715 width=...
0
votes
1
answer
146
views
How to pg_restore some tables with automatic index creation?
How to restore some table from pg_dump custom format, and automatically create it's index ?
I just restore some tables from database dump (custom format).
pg_restore -d database --table=table1 --table=...