Does vacuum full reindex?



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

Post New Answer

More Postgre Interview Questions

What is pg_toast?

1 Answers  


How do I alter a table in postgresql?

1 Answers  


Does postgres support clustering?

1 Answers  


What is composite foreign key?

1 Answers  


What is work_mem in postgresql?

1 Answers  


Who invented postgresql?

1 Answers  


How do you add a column?

1 Answers  


get second maximum date from tables.

1 Answers  


How do I rename a column in postgresql?

1 Answers  


What is difference between drop and delete?

1 Answers  


What is a foreign key constraint why are such constraints important?

1 Answers  


Is a primary key indexed?

1 Answers  


Categories