I have a table with a few million rows and this index:
CREATE INDEX bond_item_common_x7 ON bond_item_common
There are about 2M rows on bonddump and 4M rows on bond90.
bonddump is on a 8MB RAM machine, bond90 is on a 72MB RAM machine.
The table is analyzed properly both places.
I'm an index hint zealot, but aware of our different stances in the
Dropping the wildcard for the like, both databases uses the index.
Is there a way to convince Postgres to try not to do full table scan as