CODEWITHSUNDEEP
postgresqlpostgresql-9.2
Figaro88
Figaro88

Reputation: 13

postgresql 9.2 never vacuumed and analyze

I have given a postgres 9.2 DB around 20GB of size.

I looked through the database and saw that it has been never run vacuum and/or analyze on any tables. Autovacuum is on and the transaction wraparound limit is very far (only 1% of it).

I know nothing about the data activity (number of deletes,inserts, updates), but I see, it uses a lot of index and sequence. My question is:

  1. does the lack of vacuum and/or analyze affect data integrity (for example a select doesn't show all the rows matches the select from a table or from an index)? The speed of querys and writes doesn't matter.

  2. is it possible that after the vacuum and/or analyze the same query gives a different answer than it would executed before the vacuum/analyze command?

I'm fairly new to PG, thank you for your help!!

Regards, Figaro88

Upvotes: 1

Views: 1565

Answers (1)

Dwayne Towell
Dwayne Towell

Reputation: 8583

Running vacuum and/or analyze will not change the result set produced by any select operation (unless there was a bug in PostgreSQL). They may effect the order of results if you do not supply an ORDER BY clause.

Upvotes: 3

Related Questions