On 25 May 2015 at 11:48, Amit Langote <langote_amit...@lab.ntt.co.jp> wrote:
> On 2015-05-25 PM 06:26, Colin 't Hart wrote: > > That means the specified order of columns in a query does matter which > would > have to match the defined order in order to avoid extra processing (that is > only when specified columns *exactly* matches the tuple descriptor). > ...and it matters a lot in those cases because we are sorting all of the data scanned, not just 25 rows. -- Simon Riggs http://www.2ndQuadrant.com/ <http://www.2ndquadrant.com/> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
