Stack Overflow
Stack Overflow

Questions tagged [vacuum]

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

232 questions
2
votes
2 answers

Using Sqlite3 VACUUM command on Core Data SQLite Persistent store

In our app, we are implementing sharing of partial Core Data SQLite database through network/email. In order to keep the file size small, I have implemented the below method to shrink the Core Data database. - (void) shrinkDB { …
Dhanush
  • 104
  • 1
  • 4
1
vote
1 answer

How can I simulate transaction ID wraparound in Postgres?

I'm trying to get a better understanding of how XID wraparound affects the results of the query to find the snapshot xmin (that is txid_snapshot_xmin(txid_current_snapshot()) or pg_snapshot_xmin(pg_snapshot_current()) after Postgres 13) and the…
Dev K
  • 41
  • 2
1
vote
1 answer

Vacuum of empty table takes 3 seconds

Running vacuum on some of our systems takes 3 seconds for an empty table: create table t (c int); vacuum t; -- 3 seconds vacuum t; -- 3 seconds vacuum t; -- 3 seconds ... On my local installation it takes only milliseconds. Why is it so slow on…
Peter
  • 932
  • 5
  • 19
1
vote
1 answer

Flutter Sqflite Runtime Vacuum

I'm using sqflite database as asset database that contains one table which size is around 5MB. User activities are changing some of the fields in that table. I'm considering to apply scheduled vacuum command in runtime (on mobile device) to be able…
Nurol Alacaatli
  • 81
  • 10
1
vote
1 answer

Autovacuum and partitioned tables

Postgres doc tells that partitioned tables are not processed by autovacuum. But still I see that last_autovacuum column from pg_stat_user_tables is populated with recent timestamps for live partitions. Does it mean that these timestamps are set by…
user3714601
  • 1,156
  • 9
  • 27
1
vote
0 answers

Is there a way to VACUUM an sqlite3 database in parts to avoid OperationalError: database or disk is full/reduce size of sqlite3 databse

I have a rather large sqlite3 database that I've built/populated through python over a few months. I have done many inserts/deletes etc while putting it together and it now uses the majority of my diskspace so I don't have enough disk space left to…
Emi OB
  • 2,814
  • 3
  • 13
  • 29
1
vote
1 answer

How to find tables processed by VACCUM(FULL, ANALYZE) but not VERBOSE

So I have cancelled a global VACUUM FULL out of necessity, there will be tables that were not processed and can now be individually targeted. Problem. VACUUM(FULL, ANALYZE) does not update last_vacuum, a known issue for a decade? How can I identify…
mckenzm
  • 1,545
  • 1
  • 12
  • 19
1
vote
0 answers

Why VACUUM FULL doesn't shrink the size of my table?

I'm struggling with a bloated table that I'm unable to shrink. It has just 6 rows but its size is 140MB+ and it's continously updated\deleted by quick transactions. I tried using VACUUM and VACUUM FULL but there's no result. These are the table…
Giorgio Morina
  • 11
  • 2
1
vote
1 answer

PostgreSQL 13 - "Vacuum full" process killed but disk does't free up

I have killed the VACUUM FULL was running on a database since 5 hrs. Before initiation the disk was 286 GB free and the VACUUM full took 150 GB while processing. My question is , Why the 150 GB is not released after the process is killed? and how…
Siddheshwar Soni
  • 182
  • 1
  • 7
1
vote
2 answers

How can we validate a Postgres database backup is not corrupted?

Is there a efficient way to check if the Postgres backups (for managed services like RDS and Cloudsql) are not corrupted? Currently one of the ways we are implementing this check is in the following way: spin up a new DB from the backup and run a…
Dev Babai
  • 53
  • 1
  • 7
1
vote
2 answers

PSQL: VACUUM ANALYZE is showing incorrect oldest xmin

When I run vacuum verbose on a table, the result is showing an oldest xmin value of 9696975, as shown below: table_xxx: found 0 removable, 41472710 nonremovable row versions in 482550 out of 482550 pages DETAIL: 41331110 dead row versions cannot…
thomas
  • 11
  • 3
1
vote
1 answer

Is it always possible to UPDATE a database after a VACUUM FREEZE?

If I do a VACUUM FREEZE on a database, is it always possible to update the frozen rows in the database? Or is VACUUM FREEZE very dangerous because the rows become immutable? That would be a disaster in production!
Christophe Leray
  • 37
  • 4
1
vote
1 answer

No much improvement on max transaction id after vacuum full

We did a vacuum full on our table and toast. The dead tuples dropped drastically, however the max transaction id stays pretty much the same. My question is, why did it the max transaction id not go down as dead tuples go down…
somenickname
  • 539
  • 7
  • 19
1
vote
1 answer

database vacuum to avoid transaction wrap around

Platform Heroku PG version 13 I have a very busy database and it is reaching near transaction wrap around. At this point I really want to do the vacuum manually. My question is that if I do manual vacuuming of individual tables then I can see that…
hassan_i
  • 301
  • 2
  • 8
1
vote
1 answer

Effect of vacuum freeze in Postgresql

I am using postgresql for cloudSQL on GCP. One table is almost in the process of inserting. (Theoretically more than 10 million per day) Auto vacuum was performed when the data was about 10 billion. Also, while auto vacuum was running, other…
Hyungsik Jo
  • 146
  • 1
  • 14
1 2 3
…
15 16