>>>>> "JL" == Jean-Luc Lachance <jllachan@nsd.ca> writes:
JL> BULL.
JL> How many times does PG have to scan the whole table because of MVCC?
JL> At least with partitioning there is a fighting chance that that won't be
JL> necessary.
Huh? His specific query was "WHERE md5 = '....'". Why on earth would
that force a sequence scan if it were an indexed column? Heck, the
btree index should rule out 15/16ths of the rows after the first
character comparison.