Robert Haas <robertmh...@gmail.com> writes: > I agree that we should have some way for foreign data wrappers and > custom scans and perhaps also other executor nodes to find out whether > there's a known limit to the number of tuples that they might need to > produce, but I wonder if we should be doing something more general > than this.
I had the same feeling that this could stand to be considered more generally, but had not had time to consider it in detail. The bound passdown from Limit to Sort was never anything but a quick-and-dirty private hack, and I'm not very comfortable with just exposing it to the whole world without reconsidering the design. > On a more practical level, I notice that you haven't adapted > postgres_fdw or file_fdw to benefit from this new callback. It seems > like postgres_fdw could benefit, because it could fetch only the > required number of tuples if that happens to be a smaller number than > the configured fetch_size. I think we should insist on that, either in the base patch or a followup patch, because you never know if a hook is actually convenient to use until you try. regards, tom lane -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers