Is Optimizer smart enough?

From: tmorelli(at)tmorelli(dot)com(dot)br
To: pgsql-hackers(at)postgresql(dot)org
Subject: Is Optimizer smart enough?
Date: 2006-01-10 23:50:23
Message-ID: 20060110235023.B2CEEF368E@smtpi01.infolink.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Just for curiosity: suppose there is an excellent index frequently picked by
the optimizer. Suppose now that this index became extremelly fragmented with
thousands of updates. Without a REINDEX, will Optimizer still pick it? Or the
optimizer is smart enough to detect index fragmentation and discard it?

Is there something that I could do in btcostesimate function to detect
increasing index fragmentation?

best regards,

Eduardo Morelli

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2006-01-11 01:15:02 Re: A question about index internals
Previous Message Jim C. Nasby 2006-01-10 23:39:31 Re: Improving N-Distinct estimation by ANALYZE