pgsql: Improve sorting speed by pre-extracting the first sort-key column

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve sorting speed by pre-extracting the first sort-key column
Date: 2006-02-26 22:58:13
Message-ID: 20060226225813.1F6839DC810@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Improve sorting speed by pre-extracting the first sort-key column of
each tuple, as per my proposal of several days ago. Also, clean up
sort memory management by keeping all working data in a separate memory
context, and refine the handling of low-memory conditions.

Modified Files:
--------------
pgsql/src/backend/executor:
nodeSort.c (r1.52 -> r1.53)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeSort.c.diff?r1=1.52&r2=1.53)
pgsql/src/backend/utils/sort:
tuplesort.c (r1.59 -> r1.60)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/sort/tuplesort.c.diff?r1=1.59&r2=1.60)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2006-02-27 01:41:16 pgsql: Add mention that tid perhaps someday should be output as a
Previous Message Neil Conway 2006-02-26 22:26:40 pgsql: Fix a few minor typos in comments in PL/Perl.