On 12 December 2014 at 03:22, Simon Riggs <simon@xxxxxxxxxxxxxxx> wrote: > It's a simple patch, but it solves the test cases I know about and > does almost nothing to planning time. Test cases attached. The files marked "pettus_*" are written up from Christophe Pettus' blog. The other test case is one of my own devising, based upon recent customer problems. The "10 most recent calls" is a restatement of actual problems seen in the past. Also attached is a new parameter called enable_sortedpath which can be used to turn on/off the sorted path generated by the planner. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Attachment:
sortedpath.sql
Description: Binary data
Attachment:
pettus_limit.sql
Description: Binary data
Attachment:
pettus_sel.sql
Description: Binary data
-- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
