index maybe not used on maintenance

sraoss / pgsql-ivm

IVM (Incremental View Maintenance) development for PostgreSQL

Other

129 stars 12 forks source link

index maybe not used on maintenance #131

Open MengqiWu opened 3 years ago

MengqiWu commented 3 years ago

in apply_delta() maybe just use all attributes not consider the index created when create ivm /*

For views without aggregates, all attributes are used as keys to identify a
tuple in a view. */ if (!query->hasAggs) keys = lappend(keys, attr);

yugo-n commented 3 years ago

// I'm sorry for late replay.

Thank you for your feedback! That's good point. Actually, the index is used even when all attributes are used as a key, but we don't have to use some attributes if we have a unique key. I'll consider to fix this.