Re: [GENERAL] Same-page UPDATEs in bloated tables

2006-10-15 Thread Ian Dowse
In message <[EMAIL PROTECTED]>, Tom Lane writes: >Alvaro Herrera <[EMAIL PROTECTED]> writes: >> Using the same page for an updated tuple is generally a useful >> optimization, so I don't think you have much hopes for having it >> disabled. > >Especially not since there's no very reasonable way for

Re: [GENERAL] Same-page UPDATEs in bloated tables

2006-10-15 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Using the same page for an updated tuple is generally a useful > optimization, so I don't think you have much hopes for having it > disabled. Especially not since there's no very reasonable way for anything as low-level as heap_update to know that "the

Re: [GENERAL] Same-page UPDATEs in bloated tables

2006-10-15 Thread Alvaro Herrera
Ian Dowse wrote: > I've been seeing an issue with 8.1.4 that seems to be caused by the > way UPDATE operations prefer to place the new row version in the > same page as the original row. The issue is specific to UPDATEs; > it does not occur when each UPDATE is replaced by a DELETE/INSERT > pair. T