Re: Tuning single row operations

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