Stack Overflow
Stack Overflow

Questions tagged [vacuum]

In SQLite and PosgreSQL, the VACUUM command rebuilds the entire database.

232 questions
0
votes
0 answers

PostgreSQL: Run vacuumlo on a specific schema

is it possible to run the vacuumlo tool only on a specific schema of a database? I can only run it on a complete database, but that is not what i want.
Guhopa
  • 1
  • 1
0
votes
1 answer

How to VACUUM a SQLite database from within an Alembic migration?

I am using SqlAlchemy Alembic to perform DB migrations on a SQLite database. One of my migrations removes many redundant records and I would like to VACUUM the database after the deletion. Here's how I'm trying to do this in my migration's…
urig
  • 16,016
  • 26
  • 115
  • 184
0
votes
1 answer

How do I chain a VACUUM off of a purge routine running with pg_cron?

Postgres 13.4 I've got some pg_cron jobs set up to periodically delete older records out of log-like files. What I'd like to do is to run VACUUM ANALYZE after performing a purge. Unfortunately, I can't work out how to do this in a stored function.…
Morris de Oryx
  • 1,857
  • 10
  • 28
0
votes
1 answer

Need help in using the 'analyze-in-stages' option of the vacuumdb command

I have a PostgreSQL 10 cluster containing many databases, the total size is 500 Gb. I have launched the vacuumdb command using the analyze-in-stages option : vacuumdb --all --verbose --analyze-in-stages and I have seen in the output : vacuumdb:…
Frederic KAPP
  • 41
  • 2
0
votes
1 answer

Optimal Postgres partitioning based on date

I am looking at ways to improve deletion of data in my Postgres (partitioned) tables, not worsening the access performance. Using: Postgres 10.2 Ignoring some unrelated columns, I have the table transactions with these columns (omitting some…
Chillax
  • 4,418
  • 21
  • 56
  • 91
0
votes
1 answer

Why does Postgres VACUUM FULL ANALYZE gives performance boost but VACUUM ANALYZE does not

I have a large database with the largest tables having more than 30 million records. The database server is a dedicated server with 64 cores, 128 GB RAM running ubuntu and postgres 12. So the server is more powerful than we normally need. The server…
Omer Farooq
  • 3,754
  • 6
  • 31
  • 60
0
votes
1 answer

Redshift Vacuum No Impact

I have a few large tables (~1/2bn rows) on AWS Redshift. These tables have a small pct_unsorted as they're Vacuum'ed every weekend. The pct_unsorted climbs by 0.5% everyday due to new records. I use SVV_TABLES and SVV_TABLE_INFO to find out the…
finn871
  • 33
  • 7
0
votes
2 answers

Vacuuming Delta tables in Databricks does not work

I'm trying to vacuum my Delta tables in Databricks. However, somehow it is not working and I don't understand why. This is causing our storage constantly increasing. I have set the following table properties: %sql ALTER TABLE SET…
MCL94
  • 21
  • 1
  • 5
0
votes
1 answer

PostgreSQL: how to clean up full disk space after unsuccessful ALTER TABLE?

I have an instance of PostgreSQL on DigitalOcean. A part of the tables are stored in tablespaces on a separate machine (block volume). Around 90% of the block volume were full when I tried altering some fields in Django. My command was unable to…
Edmond
  • 59
  • 2
  • 15
0
votes
1 answer

Intereat Vacuun cleaner Cybovac E31 for home automation

I search a way to control my CybovacE31 with a computer to integrate it into home automation system. I know that it is compatible with google home and Alexa but i don't find the protocol used. Do you have an idea how to do it? Thanks. My vacuum :…
Yvann Ponce
  • 41
  • 3
0
votes
0 answers

Vacuum Full calibration for production context.(reorganize subjects identification)

My aim is to calibrate vacuum full usage within production context, knowing that vacuum full locks exclusively objects that I need to maintain. how should I identify only the list of objects where the vacuum full is worth it? How do I convert dead…
Aymanadou
  • 1,200
  • 1
  • 14
  • 36
0
votes
1 answer

Redshift vacuum is not reclaiming space

I have a Redshift cluster that consists of 2 nodes with 160 Gb disks. I'm randomly getting "Disk full" error when running vacuum or any other query. My disk usage is 92%. I did delete more than a half of the old rows in table that is 10515 Mb in…
viktor117
  • 21
  • 4
0
votes
0 answers

Improve query performance by running ANALYZE?

PostgreSQL version: 12.4 TimescaleDB version: 1.7.4 Hi, I have a table in which data is distributed in multiple chunks based on time only i.e. created hypertables for one day. I am trying to improve the performance of SELECT query. To achieve that…
Satish Kumar
  • 63
  • 6
0
votes
1 answer

PostgreSQL failed with vacuum and autovacuum

Postgres v11.9 There are many errors on Postgres log like this: 2020-09-05 17:35:37 GMT [22464]: @: [6-1] ERROR: uncommitted xmin 636700836 from before xid cutoff 809126794 needs to be frozen 2020-09-05 17:35:37 GMT [22464]: @: [7-1] CONTEXT: …
Ivan Alex Khokhlov
  • 13
  • 4
0
votes
0 answers

found xmin 2965836007 from before relfrozenxid 1749

Autovacuum is not working on our AWS RDS PostgreSQL server from past few days. We run a manual vacuum to check the issue but we are getting below error for every database. vacuumdb: vacuuming of database "databasename" failed: ERROR: found xmin…
YogeshR
  • 1,606
  • 2
  • 22
  • 43
1 2 3
…
15 16