Neil, I agree with Bruce and Tom. AFAIK and in my experience I don't think it will be a significantly measurable increase. Not only that, but the portability issue itself tends to make it less desireable. I recently ported SAP DB and the coinciding DevTools over to OpenBSD and learned again first-hand what a pain in the ass having platform-specific code is. I guess it's up to you, Neil. If you want to spend the time trying to implement it, and it does prove to have a significant performance increase I'd say maybe. IMHO, I just think that time could be better spent improving the current system rather than trying to add to it in a singular way. Sorry if my comments are out-of-line on this one but it has been a thread for some time I'm just kinda tired of reading theory vs proof.
Since you are so set on trying to implement this, I'm just wondering what documentation has tested evidence of measurable increases in similar situations? I just like arguments to be backed by proof... and I'm sure there is documentation on this somewhere. -Jonah -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Momjian Sent: Sunday, September 29, 2002 3:30 PM To: Tom Lane Cc: Neil Conway; PostgreSQL Hackers Subject: Re: [HACKERS] making use of large TLB pages Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > Bruce Momjian <[EMAIL PROTECTED]> writes: > >> OK, personally, I would like to see an actual speedup of PostgreSQL > >> queries before I would apply such a OS-specific, version-specific > >> patch. > > > Don't be silly. A performance improvement is a performance > > improvement. > > No, Bruce was saying that he wanted to see demonstrable improvement > *due to this specific change* before committing to support a > platform-specific API. I agree with him, actually. If you do the > TLB code and can't measure any meaningful performance improvement > when using it vs. when not, I'd not be excited about cluttering the > distribution with it. > > > I think it's at least worth implementing -- if it doesn't provide a > > noticeable performance improvement, then we don't need to merge it. > > You're on the same page, you just don't realize it... I see what he thought I said, I just can't figure out how he read it that way. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
