Stack Overflow
Stack Overflow

Questions tagged [vacuum]

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

232 questions
0
votes
1 answer

VACUUMs executed in parallel

In my application n microservices are running on m nodes. Each microservice has its own database and is responsible for issuing VACUUM ANALYZE once in a while. Since the scheduling of this routine job is the same for each microservice, in my naive…
tobi
  • 81
  • 6
0
votes
0 answers

Disk space Postgres database gets full eventhough Vacuum

I have a database which is constantly written by different servers. The problem I have is that even though I vacuum the database, the disk available is progressively in time getting reduced. This is an image of a 16 day period: As you see the trend…
Hector Esteban
  • 1,011
  • 1
  • 14
  • 29
0
votes
2 answers

Postgres Upsert - fragmentation issues

Summary I am using Postgres UPSERTs in our ETLs and I'm experiencing issues with fragmentation and bloat on the tables I am writing to, which is slowing down all operations including reads. Context I have hourly batch ETLs upserting into tables…
Rob
  • 3
  • 3
0
votes
3 answers

PostgreSQL: DELETE won't free memory

I use PostgreSQL on an embedded system with limited drive space. Now the DB-drive is full. When I delete data, it doesn't seem to free up any space. I tried to VACUUM FULL, but that requires space. So does deleting the last remaining index. Any…
MrB
  • 2,155
  • 7
  • 27
  • 33
0
votes
1 answer

Postgresql-8.4 auto vacuum is enabled to get the best performance

I want know which one is good to follow whether auto vacuum or vacuum manually. Right now we are following manually in cron jobs, but sometimes it gets struck to vaccum on particular tables. so we are thinking about the auto vacuum. does it give…
sathish
  • 9
  • 1
0
votes
1 answer

debugging postgres 9.0.1 table corruption

I have a 9.0.1 database with two corrupted tables (one table has 20 rows, the other 140). The tables seem fine for read/select operations, but updating certain rows in the table produce error messages: update media set updated_at = now() at time…
Dan B
  • 131
  • 1
  • 6
0
votes
0 answers

Is it possible to connect many (20+) SPI sensors to an Arduino Mega?

I am making a system for measuring whether or not there is vacuum present in big steel containers. They are located up to 100 meters from the control cabinet. The question is, how many SPI sensors can I successfully use at the same time with an…
Vincent Vega
  • 119
  • 10
0
votes
0 answers

sqlite3 DB doesn't use index unless vacuumed

Performing VACUUM on my DB significantly improves query performance. While trying to determine why this is, I found that sqlite3 isn't using the index on the DB in its original state, just a generic SEARCH TABLE. QUERY PLAN |--SCAN TABLE data …
Numpty
  • 1,461
  • 5
  • 19
  • 28
0
votes
1 answer

Redshift vacuum sort default

"By default, VACUUM skips the sort phase for any table where more than 95 percent of the table's rows are already sorted" Is there a reason why the default is 95 and not 100? Is the performance increase of a 100% to 95% sorted table negligible?
pippa dupree
  • 155
  • 1
  • 10
0
votes
2 answers

Shrinking pg_toast on RDS instance

I have a Postgres 9.6 RDS instance and it is growing 1GB a day. We have made some optimizations to the relation related to the pg_toast but the pg_toast size is not changing. Autovacuum is on, but since autovacuum/VACUUM FREEZE do not reclaim space…
nael
  • 1,441
  • 19
  • 36
0
votes
1 answer

Are dead rows removed by anything else than vacuum?

In PostgreSQL 9.3.19 log I see the following two consecutive entries for autovacuum of a given table: 2018-06-29 17:24:06 CDT 13177 14/870454 0 LOG: automatic vacuum of table "openbravo.public.ad_session_status": index scans: 0 pages: 0…
alostale
  • 770
  • 1
  • 11
  • 21
0
votes
1 answer

Amazon Redshift - Vacuum and Analyze details

Is it possible to view the history of all vacuum and analyze commands executed for a specific table in Amazon Redshift.
dark horse
  • 3,211
  • 8
  • 19
  • 35
0
votes
1 answer

Postgresql 9.3 Autovacuum not keeping up despite aggressive settings

Trying to get Postgresql to keep tables a lot cleaner however even after tweaking resource limits it doesn't seem to be keeping up hardly at all. Even after setting ALTER TABLE veryactivetable SET (autovacuum_vacuum_threshold = 10000); the…
Toomuchcode
  • 1
  • 1
0
votes
1 answer

Run vacuum by schedule

I'm using Postgres version 9.6 Most of my tables are for queries, update, insert. Most of them around 200K-700K. There are bigger (millions) and smaller. Is that a good idea to perform vacuum (and analyze?) operation once a day? once a week? …
user2671057
  • 1,411
  • 2
  • 25
  • 43
0
votes
0 answers

auto vacuum/vacuum not releasing dead rows in PostgreSQL 9.6

All, Please suggest here, auto vacuum/vacuum is not releasing the dead rows for a table in postgreSQL 9.6 version, can anyone help what needs to be checked here or is there any parameter tune to remove dead rows. Regards, Varun
varun kamal
  • 1
  • 3
1 2 3
…
15 16