Re: [HACKERS] Question regarding clock-sweep

2005-04-11 Thread Josh Berkus
Tom, > There's not any special smarts for seqscans, but the counter should > handle that. So all pages start out with the same counter, except VACUUM tuples? BTW, I found this paper on RDBMS memory management, which probably could have saved us some weeks of discussion: http://www.cs.usask.ca/~

Re: [HACKERS] Question regarding clock-sweep

2005-04-11 Thread Josh Berkus
Tom, Neil, > > Oh, and incidentally, can I use the same database files for 8.0.2 and > > 8.1cvs 3/10/05? > > Sorry, we forced initdb already several times... D'oh. Better see if I can get a second machine, then, since build of a 100G DBT3 database takes 20 hours. -- Josh Berkus Aglio Database

Re: [HACKERS] Question regarding clock-sweep

2005-04-10 Thread Tom Lane
Josh Berkus writes: > Now that I'm beginning serious performance testing of clock-sweep, I > was going back through the lock discussion and am not sure what the > patch that actually went in 3 weeks ago consisted of. Is it > clock-sweep with a used/unused bit or a counter? How is it handling > s

Re: [HACKERS] Question regarding clock-sweep

2005-04-10 Thread Neil Conway
Josh Berkus wrote: Oh, and incidentally, can I use the same database files for 8.0.2 and 8.1cvs 3/10/05? No. -Neil ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL P

[HACKERS] Question regarding clock-sweep

2005-04-10 Thread Josh Berkus
Tom, Now that I'm beginning serious performance testing of clock-sweep, I was going back through the lock discussion and am not sure what the patch that actually went in 3 weeks ago consisted of. Is it clock-sweep with a used/unused bit or a counter? How is it handling seq scans? Oh, and i