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. Join them; it only takes a minute:

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

I've done some performance analysis on my DB and I have releved that:

Read head 8192
CPU power used 25%
Bloating 56% (84GB of 150) 20% occupied by index unused

Now I have find that 99% of operations are in SELECT but bloating effect send me a feedback that this it's not true because seems that spare indexes and triples are caused by FILL Factor default value to 100.

Which could be cause of bloating? My analysis it's truly?


migration rejected from Mar 12 '14 at 14:18

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as unclear what you're asking by dezso, Mark Storey-Smith, a_horse_with_no_name, ypercubeᵀᴹ, Michael - sqlbot Mar 12 '14 at 14:18

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

Do you vacuum - – plaes Mar 12 '14 at 7:41
Er, what? Done "some performance analysis" with what, exactly? How did you determine the above? What does "read head" even mean - do you mean readahead? "cpu power used" - how many cores? 25% of a quad-core is 100% of one core. – Craig Ringer Mar 12 '14 at 7:42
Also, fillfactor settings won't create additional indexes, never. – dezso Mar 12 '14 at 10:14