Re: [PERFORM] A Better External Sort?

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] A Better External Sort?
Date: 2005-09-30 21:31:32
Message-ID: D425483C2C5C9F49B5B7A41F8944154757D140@postal.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

I see the following routines that seem to be related to sorting.

If I were to examine these routines to consider ways to improve it, what
routines should I key in on? I am guessing that tuplesort.c is the hub
of activity for database sorting.

Directory of U:\postgresql-snapshot\src\backend\access\nbtree

08/11/2005 06:22 AM 24,968 nbtsort.c
1 File(s) 24,968 bytes

Directory of U:\postgresql-snapshot\src\backend\executor

03/16/2005 01:38 PM 7,418 nodeSort.c
1 File(s) 7,418 bytes

Directory of U:\postgresql-snapshot\src\backend\utils\sort

09/23/2005 08:36 AM 67,585 tuplesort.c
1 File(s) 67,585 bytes

Directory of U:\postgresql-snapshot\src\bin\pg_dump

06/29/2005 08:03 PM 31,620 pg_dump_sort.c
1 File(s) 31,620 bytes

Directory of U:\postgresql-snapshot\src\port

07/27/2005 09:03 PM 5,077 qsort.c
1 File(s) 5,077 bytes

Browse pgsql-hackers by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2005-09-30 21:40:41 Re: postgresql clustering
Previous Message Simon Riggs 2005-09-30 20:54:39 Re: effective SELECT from child tables

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2005-09-30 21:45:10 Re: [PERFORM] A Better External Sort?
Previous Message Tony Wasson 2005-09-30 20:57:16 Re: Monitoring Postgresql performance