Re: [HACKERS] Update comment for README.HOT

2010-09-19 Thread Bruce Momjian
Applied. --- Bruce Momjian wrote: > Tom Lane wrote: > > Bruce Momjian writes: > > > + This means that UPDATE, DELETE, and SELECT can trigger space > > > + reclamation, while INSERT ... VALUES cannot because it does not retr

Re: [HACKERS] Update comment for README.HOT

2010-09-17 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian writes: > > + This means that UPDATE, DELETE, and SELECT can trigger space > > + reclamation, while INSERT ... VALUES cannot because it does not retrieve > > + a row. > > I don't believe that's correct. It might have happened to work that way > for you in a partic

Re: [HACKERS] Update comment for README.HOT

2010-09-17 Thread Bruce Momjian
Thom Brown wrote: > On 17 September 2010 20:52, Bruce Momjian wrote: > > I would like to apply the attached patch to README.HOT so clarify when > > single-page cleanup happens, e.g. not during INSERT. > > > > "... when the page is nearly full (<10%) ..." > > Shouldn't that be >90%? > > "... whi

Re: [HACKERS] Update comment for README.HOT

2010-09-17 Thread Tom Lane
Bruce Momjian writes: > + This means that UPDATE, DELETE, and SELECT can trigger space > + reclamation, while INSERT ... VALUES cannot because it does not retrieve > + a row. I don't believe that's correct. It might have happened to work that way for you in a particular test. It's certainly not

Re: [HACKERS] Update comment for README.HOT

2010-09-17 Thread Thom Brown
On 17 September 2010 20:52, Bruce Momjian wrote: > I would like to apply the attached patch to README.HOT so clarify when > single-page cleanup happens, e.g. not during INSERT. > "... when the page is nearly full (<10%) ..." Shouldn't that be >90%? "... while INSERT ... VALUES cannot because it

[HACKERS] Update comment for README.HOT

2010-09-17 Thread Bruce Momjian
I would like to apply the attached patch to README.HOT so clarify when single-page cleanup happens, e.g. not during INSERT. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + Index: src