Re: Table partitioning for maximum speed?

>>>>> "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.