Stack Overflow
Stack Overflow

Questions tagged [vacuum]

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

232 questions
0
votes
1 answer

Separate queue for Amazon Redshift vacuums

I am considering having a separate queue for vacuum queries with concurrency set to 1 in WLM (Workload Management). Am choosing concurrency 1 because only a single vacuum query can run at any given moment. I am trying to think if there will be any…
Pratik Khadloya
  • 12,509
  • 11
  • 81
  • 106
0
votes
1 answer

org.postgresql.util.PSQLException: Error could not open file "base/16384/19048": No such file or directory

Few of the tables and indexes are bloated though auto vacuum has enables. Two reclaim the space vacuum, I have ran vacuum full on the larger tables and also performed reindex on the indexes which are in larger size. Now the size of the database is…
Raghavendra
  • 519
  • 1
  • 11
  • 25
0
votes
1 answer

vacuum necessity and effectivness

gurus! Please share sql-queries which you are using to estimate that vacuum is mandatory and see how it was effective. It should show something like unused space or existing/deleted rows ratio, etc.
SeventhSon
  • 71
  • 5
0
votes
0 answers

Postgres AUTO_VACUUM (to prevent wrap-around) manually activating

Running postgres 9.6, big data table lots of transactions occurring on table. After every 100,000 changes (or so) a VACUUM FREEZE is run against the table. My understanding was that this would do the same as the AUTO_VACUUM (to prevent wrap-around)…
notzippy
  • 468
  • 7
  • 10
0
votes
1 answer

postgresql performance optimization - rebuild db

Our postgresql db has a no-usage window of 2am to 6am. one of the daily cron jobs already does a VACUUM FULL during this period. i am seeing no real performance hit with the ~200 odd users who use the web site. but the db is what i would classify as…
deepakkt
  • 82
  • 1
  • 8
0
votes
0 answers

Apply lock to a postgres database

I'm doing a vacuum full in my postgres server and I have some issues, so I would like to lock all "postgres" database in my postgresql server. I would not lock juste table. How can I do that ? thanks.
user7127267
0
votes
2 answers

PostgreSQL select a frequently updated row from a small table

I'm using PostgreSQL 9.6 (Ubuntu 16.04) and I have a small table T of about 10k rows, where each row is updated 2 times per minute in peak times (something like UPDATE T SET c1 = ?, c2 = ? WHERE id = ?). Futhermore, this is the only update operation…
Diogo M. Santana
  • 148
  • 2
  • 8
0
votes
0 answers

Postgresql Vacuum blocked, I want ignore some tables

I automatically run a script that performs a FULL VACUUM on my Posrtgresql databases but today it crashed because the process was blocked (surely by another operation on the table). I want to make sure that he ignores the tables on which there is…
user7127267
0
votes
1 answer

Postgresql 9.2.1 failed to initialize after full vacuum in standalone backend mode

In postgresql version 9.2.1, the database didn't accept any commands to avoid wraparouond dataloss.The following error occured in the pg_log, ERROR: database is not accepting commands to avoid wraparound data loss in database "XXX" HINT: Stop…
Eddie
  • 91
  • 2
  • 10
0
votes
1 answer

Redshift query results incorrect before VACUUM

When Redshift uses an index to run a query (say counts), does it exclude counting the rows in the unsorted region? I had copied a lot a data using the COPY command, but did not VACUUM the table afterwords. On running my query (involving joins with…
hrs
  • 41
  • 1
  • 4
0
votes
1 answer

Amazon Redshift VACUUM was not successful

My table had 17500000 rows, I deleted 500k rows. After deleting, I ran the vacuum command. According to SVV_VACUUM_SUMMARY, row_delta is difference in the total number of table rows before and after the vacuum. But when I saw the SVV_VACUUM_SUMMARY…
Chirag Sejpal
  • 877
  • 2
  • 9
  • 17
0
votes
0 answers

Executing vacuuming on a postgres table

I had speed issues displaying a layer in Geoserver. The layer is retrieved through a postgres store. I have run auto-vacuum on the table (16million rows) and then things being faster. The issue is that I don't know why they are faster. Based on the…
user1919
  • 3,818
  • 17
  • 62
  • 97
0
votes
1 answer

VACUUM sqlite database from the SQLiteOpenHelper

My app's database keeps growing and I want to perform a VACUUM to retrieve some lost space. From what I've read VACUUM does not run if there are other transactions. My question is: how do I run the command from my SQLiteOpenHelper? is something like…
Alin
  • 14,809
  • 40
  • 129
  • 218
0
votes
1 answer

sqlite3 vacuum,How to use on cordova APP

I have a big problem with the command VACUUM to free the memory from delete´s SQL sentences. Im making a Cordova Android APP, and i know when i use a DELETE SQL sentence the space of the app don't down,... the space persist like a fragment…
Armando
  • 43
  • 6
0
votes
1 answer

Move truncated records to another table in Postgresql 9.5

Problem is following: remove all records from one table, and insert them to another. I have a table that is partitioned by date criteria. To avoid partitioning each record one by one, I'm collecting the data in one table, and periodically move them…
Pawel P
  • 131
  • 5
1 2 3
…
15 16