From: | Martin Handsteiner <martin(dot)handsteiner(at)sibvisions(dot)com> |
---|---|
To: | "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org> |
Subject: | Optimizer Hint, to ignore limit and offset in optimizer plan |
Date: | 2020-06-26 08:49:19 |
Message-ID: | VI1PR1001MB1423F5361320BB854708FD2FE8930@VI1PR1001MB1423.EURPRD10.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I'm aware, that taking limit and offset into account of optimizer plan is not a bug.
Nevertheless it is very often an unwanted feature.
As the postgres db has the issue with not supporting cursors over commit/ rollback, it is necessary to use the limit and offset mechanism.
The problem now is, with either
* not always possible to ensure a proper sort (application with sort on header click),
* and also on complex queries and a lot of data, that will be slow when sorting the result.
So if there would be an optimizer hint, that tells the optimizer to ignore limit and offset on generating a plan, it would be perfect.
Mainly having the same optimizer plan without looking on limit and offset, the possibitlity of having mixed data is drastically reduced.
Is there possibly already an optimizer hint, to trickout the optimizer, and tell him, that I want all the data, even if there is for eg a limit 10 clause in the select?
Thanks
Martin
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2020-06-26 09:01:55 | Re: Optimizer Hint, to ignore limit and offset in optimizer plan |
Previous Message | Joseph | 2020-06-08 19:12:01 | Re: Persisting Query tabs/contents over restart |