Postgres Pro
Downloads
Home   >   mailing lists

Re: WIP: Upper planner pathification - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: WIP: Upper planner pathification
Date
Msg-id CAPpHfdtV4B_cT9kz4X4rjwc3xw7MKyW2nME5cD5ifqzOvmmDaw@mail.gmail.com
Whole thread Raw
In response to Re: WIP: Upper planner pathification  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WIP: Upper planner pathification
List pgsql-hackers
Tree view
Hi, Tom!

I have a question about Sort path. AFAICS this question wasn't mentioned in the upthread discussion.
We're producing Sort plans in two ways: from explicit Sort paths, and from other paths which implicitly assumes sorting (like MergeJoin path).
Would it be better to produce Sort plan only from explicit Sort path? Thus, MergeJoin path would add explicit children Sort paths. That would be more unified way.
I ask about this from point of view of my "Partial Sort" patch. The absence of implicit sorts would help to make this patch more simple and clean.

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: More stable query plans via more predictable column statistics
Next
From: Haribabu Kommi
Date:
Subject: Re: [HACKERS] Re: [HACKERS] Re: [HACKERS] Windows service is not starting so there’s message in log: FATAL: "could not create shared memory segment “Global/PostgreSQL.851401618”: Permission denied”