Does vacuum full reindex?
Answer / Veerander Kumar Yadav
No, VACUUM FULL in PostgreSQL does not reindex the table. Instead, it performs a complete rewrite of the table, replacing the old data with new data that includes updated indexes. However, if you want to rebuild an index explicitly, you should use the REINDEX command.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is pg_toast?
How do I alter a table in postgresql?
Does postgres support clustering?
What is composite foreign key?
What is work_mem in postgresql?
Who invented postgresql?
How do you add a column?
get second maximum date from tables.
How do I rename a column in postgresql?
What is difference between drop and delete?
What is a foreign key constraint why are such constraints important?
Is a primary key indexed?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)