Richard Huxton wrote:
> Simon Riggs wrote:
>> - improve RI check perf by caching small, static tables in each backend
>> - apply index filter conditions on index scan to avoid heap lookup
>
> For fkey checks against a basically static table could you get away with
> just checking the index and not the table?
I'm not sure that would fly, there is always the possibility it could
change, I think the ENUMs patch will solve this performance problem.