I'm new to PostgreSQL, I know about the concept of vacuum in database.
But I want to know the major advantages and disadvantages of vacuuming process. Also I want to know:
- What happen if I access the table while vacuuming full database?
- Whether it will affect the table, or cause data loss?