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.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to