Simon Riggs wrote:
For 8.3 my goal is to improve the performance of single row operations,

Great. That's something that's useful across the board.

Currently, I'm aware of these possibilities, some fairly vague
- avoid RI checks for update of a column not mentioned in SET

Linked at least logically - conditional triggers ("where old.status<>new.status" or similar) could save on IF statements early in trigger functions.

- 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?

  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?


Reply via email to