pg.ddx.io pgsql-committers@postgresql.org mailing list archive
help / color / mirror / Atom feedautodoc - autodoc: Minor fixes for named functions for newer DBD::Pg's.
2+ messages / 2 participants
[nested] [flat]
* autodoc - autodoc: Minor fixes for named functions for newer DBD::Pg's.
@ 2009-04-24 04:04 User Rbt <rbt@pgfoundry.org>
0 siblings, 0 replies; 2+ messages in thread
From: rbt@pgfoundry.org @ 2009-04-24 04:04 UTC (permalink / raw)
To: pgsql-committers
Log Message:
-----------
Minor fixes for named functions for newer DBD::Pg's. A long time ago DBD::Pg changed from returning an array string to returning an actual array for PostgreSQL arrays. Autodoc did not take this into account.
Modified Files:
--------------
autodoc:
postgresql_autodoc.pl (r1.21 -> r1.22)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/autodoc/autodoc/postgresql_autodoc.pl.diff?r1=1.21&r...)
^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Allow Gather Merge in more cases for parallel DISTINCT
@ 2024-02-02 11:20 David Rowley <drowley@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: David Rowley @ 2024-02-02 11:20 UTC (permalink / raw)
To: pgsql-committers@lists.postgresql.org
Allow Gather Merge in more cases for parallel DISTINCT
Here we adjust the partial path generation for parallel DISTINCT queries
to add Sort nodes on top of any unsorted partial distinct paths.
This increases the likelihood of the planner pushing a Sort below a Gather
Merge which enables the final phase of the parallel distinct to be
implemented using a Unique node in more cases.
Sorting the partial distinct paths is particularly useful when the
DISTINCT query has an ORDER BY and LIMIT clause as this can allow cheaper
plans by having the workers Hash Aggregate then Sort before feeding the
results into the Gather Merge. The non-parallel portion of the plan then
becomes very cheap as it leaves only Unique and Limit to do in the leader
process.
Author: Richard Guo
Reviewed-by: David Rowley
Discussion: https://postgr.es/m/CAMbWs48u9VoVOouJsys1qOaC9WVGVmBa+wT1dx8KvxF5GPzezA@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/7e0ade0ffe0a76b1926a4af39ecdf799c96ef1ba
Modified Files
--------------
src/backend/optimizer/plan/planner.c | 2 +-
src/test/regress/expected/select_distinct.out | 8 ++++----
2 files changed, 5 insertions(+), 5 deletions(-)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-02-02 11:20 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-04-24 04:04 autodoc - autodoc: Minor fixes for named functions for newer DBD::Pg's. User Rbt <rbt@pgfoundry.org>
2024-02-02 11:20 pgsql: Allow Gather Merge in more cases for parallel DISTINCT David Rowley <drowley@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox