Re: [HACKERS] Comments on the HOT design

2007-07-18 Thread Pavan Deolasee
On 7/18/07, Heikki Linnakangas <[EMAIL PROTECTED] > wrote: Here's what I think we should do to the HOT patch: I am all for simplifying the code. That would not only help us make it less buggy but also improve its maintainability. But we would also need to repeat the tests and run new tests t

Re: [HACKERS] Comments on the HOT design

2007-07-18 Thread Simon Riggs
On Wed, 2007-07-18 at 11:41 +0100, Heikki Linnakangas wrote: > I've done some experimenting on those items, producing several badly > broken versions of the patch partly implementing those ideas. It looks > like the patch size will go down from ~240 kB to ~210 kB, and more > importantly, there wil

[HACKERS] Comments on the HOT design

2007-07-18 Thread Heikki Linnakangas
Here's what I think we should do to the HOT patch: 1. Get rid of row-level fragmentation and handling dealing with LP_DELETEd line pointers. Instead, take a vacuum lock opportunistically, and defrag pages using the normal PageRepairFragmentation function. I'm not sure where exactly we would do the