Hannu Krosing wrote: > I guess we can't easily start locking some subarea of a page, say 256 > byte subpage, or just the tuple.
> OTOH it may be possible as we don't need to lock page header for > sequences as the tuple is updated in place and will not change in size. Huh, we _can_ lock individual tuples, using LockTuple() (or rather, heap_lock_tuple). Since the tuple is modified in place, there's no need to lock the whole page. > OTOOH, I'm afraid we still need to WAL the whole page, so the savings > will be marginal. Huh, why? We can just keep the current WAL logging for sequences, or something very similar, can't we? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
