Movatterモバイル変換

Question 1

0votes

1answer

92views

Why is there such a huge size difference between a materialized view and its PowerBI file?

I have a materialized view in postgresql. The one in question is called "Mem_Excav_NoShows".My question is why is the materialized view 1.8G in postgresql, but when loaded in PowerBI ...

Jason

339

askedOct 6 at 19:10

Question 2

0votes

2answers

115views

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 ...

Suruthi Sundararajan

9

askedJun 20 at 9:53

Question 3

1vote

1answer

147views

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/...

Dinesh Kumar

11

askedJun 17 at 1:44

Question 4

1vote

1answer

63views

Postgres Database Free Storage Space Downward

I have a situation on my Postgres 13 db on AWS.8TB of storage60GB of memory that it isn't really usingI regularly check to see if any query is running and if so, kill it.Transaction Log Disk ...

mj_

347

askedJun 7 at 23:46

Question 5

0votes

0answers

82views

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 ...

Wildcard

599

askedJun 4 at 3:23

Question 6

2votes

1answer

82views

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 ...

sevzas

375

askedApr 30 at 12:31

Question 7

2votes

2answers

154views

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 ...

goodfella

700

askedApr 30 at 3:45

Question 8

2votes

0answers

48views

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. ...

goodfella

700

askedApr 28 at 4:45

Question 9

1vote

1answer

166views

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 ...

goodfella

700

askedFeb 17 at 4:47

Question 10

0votes

1answer

90views

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 ...

Renat

101

askedJan 21 at 8:12

Question 11

0votes

0answers

49views

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 session1.1G t756_1536213694.4091.1G ...

Adam Mulla

143

askedSep 2, 2024 at 12:32

Question 12

1vote

0answers

109views

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 ...

Sheikh Wasiu Al Hasib

283

askedApr 27, 2024 at 7:06

Question 13

0votes

1answer

422views

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 ...

Sheikh Wasiu Al Hasib

283

askedApr 17, 2024 at 9:37

Question 14

0votes

1answer

223views

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=...

Mapashito

1

askedFeb 13, 2024 at 15:54

Question 15

0votes

1answer

162views

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=...

Sapta

11

askedDec 12, 2023 at 5:10

Movatterモバイル変換

Stack Exchange Network

Questions tagged [postgresql-13]

Why is there such a huge size difference between a materialized view and its PowerBI file?

What will be the root cause for the incident?

PostgreSQL 13 on Windows – “invalid page in block 0 of relation pg_index” – How to recover?

Postgres Database Free Storage Space Downward

Why can a SELECT query produce a "permission denied for schema X" error when permission IS granted for that schema?

PG 13 write performance deteriorates after OS Upgrade Win Server 2012r2 to 2019 with LWLock WALWrite statuses

PostgreSQL: Finding last executed statement from an "idle in transaction timeout"

PostgreSQL: How much memory should I allocate as ramdisk for "pg_stat_tmp"?

Replay standby WAL to point in time without creating new timeline

Cannot import a database dump on Postgres 13.14+ while it loads fine in Postgres 13.13

Temporary relation files not removed after sessions ends - Single PostgreSQL instance PostgreSQL 13

Why is the replication delay in pgpool showing a very large number?

Does long running query cause replication delay in PostgreSQL which is in 'idle in transaction' state?

Why is restored database faster than original?

How to pg_restore some tables with automatic index creation?

Hot Network Questions

Subscribe to RSS