[HACKERS] Problemas with gram.y

Hi, I'm trying to extend the CREATE INDEX statement with a fillfactor clause. In Gram.y, I did this: IndexStmt: CREATE index_opt_unique INDEX index_name ON qualified_name access_method_clause '(' index_params ')' fillfactor_clause where_clause {

[HACKERS] Is Optimizer smart enough?

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 di