]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 07c495f) | patch
Tweak planner to use OFFSET+LIMIT, not just LIMIT, as estimate of the
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 21 Feb 2000 01:13:04 +0000 (01:13 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 21 Feb 2000 01:13:04 +0000 (01:13 +0000)
commitbe05edd81296c7ec419b9af5a05460917a180b48
treefe663eba2ea82248cc05e363041b4a622124b25ctree | snapshot
parent07c495f5d86b0cc5573dd0993cdd4069b2c893cacommit | diff
Tweak planner to use OFFSET+LIMIT, not just LIMIT, as estimate of the
portion of the query result that will be retrieved.  As far as I could
tell, the consensus was that we should let the planner do the best it
can with a LIMIT query, and require the user to add ORDER BY if he
wants consistent results from different LIMIT values.
src/backend/optimizer/plan/planner.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.