On Wed, 2003-10-22 at 12:08, scott.marlowe wrote: > On Wed, 22 Oct 2003, Tom Lane wrote: > > > Rod Taylor <[EMAIL PROTECTED]> writes: > > > That said, perhaps the TODO for changing LIMIT / OFFSET to be expression > > > based should also mention bumping them to int8. > > > > Can't get excited about it ... this would slow down the normal use of > > the facility for what seems a completely hypothetical need. > > While I'm pretty sure > > select * from sometable limit 2147483648 > > isn't gonna be common, maybe someone would be likely to do something like: > > select * from sometable limit 10 offset 2147483648
> I wouldn't do it, but who knows what shadows lurk in men's minds? The overhead in simply getting to that offset is going to be significant and I would place my bets against anyone attempting that. A cursor pulling small chunks of a multi-billion tuple set is probably much more common, so we should ensure those work.
signature.asc
Description: This is a digitally signed message part
