current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top
up vote 0 down vote favorite

I want to know if I need to reindex a PostgreSql index, ith SQL Server, I check for index fragmentation and then decides whether a Rebuild, a Reorganize or no action is needed.

When should I reindex PostgreSql index? is there an index fragmentation value that I can query?

share|improve this question
    
Unfortunately there is no way to detect fragmentation of index or table. – shx Apr 3 at 15:07
    
The documentation doesn't say much about it: Routine Reindexing. – Ziggy Crueltyfree Zeitgeister Apr 4 at 2:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.