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?

              http://www.postgresql.org/docs/faq

Reply via email to