Question

Regular (AUTO)VACUUM in Postgres database does not release disk space taken by vacuum overhead

score 108 · Answer 1 · 2024-03-07T13:43:55.373000

108

Views

Regular (AUTO)VACUUM in Postgres database does not release disk space taken by vacuum overhead

Published on 07 March 2024 at 13:43

score 97 · Answer 2 · 2024-03-01T10:31:40.460000

97

Views

Temporary shutdown of autovacuum during rush hour

Published on 01 March 2024 at 10:31

score 203 · Answer 3 · 2023-11-20T22:24:10.110000

203

Views

Why have Postgres tables doubled in size after cancelling a DELETE?

Published on 20 November 2023 at 22:24

score 139 · Answer 4 · 2023-10-03T04:46:51.340000

139

Views

Postgres autovacuum stops working after relfrozenxid age hits autovacuum_freeze_max_age

Published on 03 October 2023 at 04:46

score 196 · Answer 5 · 2023-09-27T17:40:42.727000

196

Views

Autovacuum does not start. How to understand the reason? Cost-based auto vacuum is already disabled

Published on 27 September 2023 at 17:40

score 191 · Answer 6 · 2023-08-28T10:00:07.400000

191

Views

How can i tune autovacuum configs for pg toast tables?

Published on 28 August 2023 at 10:00

score 36 · Answer 7 · 2023-07-06T08:51:07.687000

36

Views

PostgreSQL autovacuum Statistic Level For Table Column

Published on 06 July 2023 at 08:51

score 148 · Answer 8 · 2023-04-14T09:13:25.103000

148

Views

postgres vacuum_freeze_min_age vs autovacuum_freeze_min_age

Published on 14 April 2023 at 09:13

score 44 · Answer 9 · 2023-04-12T11:05:00.013000

44

Views

Autovacuum struggles with 2000 tables reaching autovacuum_freeze_max_age simultaneously

Published on 12 April 2023 at 11:05

score 223 · Answer 10 · 2023-04-12T08:46:15.250000

223

Views

Vacuum of empty table takes 3 seconds

Published on 12 April 2023 at 08:46

score 206 · Answer 11 · 2023-04-11T11:00:46.660000

206

Views

Postgres wraparound prevention on unchanged table

Published on 11 April 2023 at 11:00

score 218 · Answer 12 · 2023-03-19T13:40:43.037000

218

Views

Autovacuum is holding the ShareUpdateExclusiveLock for hours

Published on 19 March 2023 at 13:40

score 522 · Answer 13 · 2023-03-17T01:34:24.237000

522

Views

Did postgres vacuum improve my query plan

Published on 17 March 2023 at 01:34

score 187 · Answer 14 · 2023-02-15T16:59:05.193000

187

Views

Postgresql : Maintaining the database and knowing more about relation/impact with each other Autovacuum , backend_xmin, datfrozenxid

Published on 15 February 2023 at 16:59

score 987 · Answer 15 · 2023-01-15T12:24:11.033000

987

Views

How to revert the auto-vacuum settings for a table in postgresql?

Published on 15 January 2023 at 12:24

score 1.4k · Answer 16 · 2022-12-23T08:46:14.620000

1.4k

Views

Postgres autovacuum to prevent wraparound (difference between usual autovacuum)

Published on 23 December 2022 at 08:46

score 453 · Answer 17 · 2022-12-22T06:07:59.223000

453

Views

Postgres query which shows when autovacuum (freeze) is launched

Published on 22 December 2022 at 06:07

score 294 · Answer 18 · 2022-12-20T07:28:51.750000

294

Views

Postgres: Autovacuum and autovacuum wraparound. When does each start?

Published on 20 December 2022 at 07:28

score 184 · Answer 19 · 2022-12-16T17:06:21.583000

184

Views

Very slow query with PostgreSQL

Published on 16 December 2022 at 17:06

score 105 · Answer 20 · 2022-12-13T09:39:40.753000

105

Views

Postgres PKey constraint violation - Old tuples are not getting Frozen

Published on 13 December 2022 at 09:39

List Question

Regular (AUTO)VACUUM in Postgres database does not release disk space taken by vacuum overhead

Temporary shutdown of autovacuum during rush hour

Why have Postgres tables doubled in size after cancelling a DELETE?

Postgres autovacuum stops working after relfrozenxid age hits autovacuum_freeze_max_age

Autovacuum does not start. How to understand the reason? Cost-based auto vacuum is already disabled

How can i tune autovacuum configs for pg toast tables?

PostgreSQL autovacuum Statistic Level For Table Column

postgres vacuum_freeze_min_age vs autovacuum_freeze_min_age

Autovacuum struggles with 2000 tables reaching autovacuum_freeze_max_age simultaneously

Vacuum of empty table takes 3 seconds

Postgres wraparound prevention on unchanged table

Autovacuum is holding the ShareUpdateExclusiveLock for hours

Did postgres vacuum improve my query plan

Postgresql : Maintaining the database and knowing more about relation/impact with each other Autovacuum , backend_xmin, datfrozenxid

How to revert the auto-vacuum settings for a table in postgresql?

Postgres autovacuum to prevent wraparound (difference between usual autovacuum)

Postgres query which shows when autovacuum (freeze) is launched

Postgres: Autovacuum and autovacuum wraparound. When does each start?

Very slow query with PostgreSQL

Postgres PKey constraint violation - Old tuples are not getting Frozen

Trending Questions

Popular # Hahtags

Popular Questions