| Lists: | pgsql-hackers |
|---|
| From: | Soroosh Sardari <soroosh(dot)sardari(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | pgsql_tmp and external sort |
| Date: | 2013-07-02 07:55:19 |
| Message-ID: | CAFUsPDYc+7ARpbeiQ6DOdkwv6n3zDGE9i+CtmmDi3UT_n=5xnA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Dear Hackers
Recently I find about pgsql_tmp directory. As I think, this directory is a
area for making temporal files which are used for external sort.
I wonder if anyone could help me to find the module of pg that is
responsible for the temporal space and external sort in the PG source code.
Regards
Soroosh Sardari
| From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
|---|---|
| To: | Soroosh Sardari <soroosh(dot)sardari(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pgsql_tmp and external sort |
| Date: | 2013-07-02 09:11:36 |
| Message-ID: | 51D29948.6000509@vmware.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On 02.07.2013 10:55, Soroosh Sardari wrote:
> Dear Hackers
>
> Recently I find about pgsql_tmp directory. As I think, this directory is a
> area for making temporal files which are used for external sort.
>
> I wonder if anyone could help me to find the module of pg that is
> responsible for the temporal space and external sort in the PG source code.
See src/backend/utils/sort/tuplesort.c and
src/backend/storage/file/buffile.c for starters.
- Heikki
| From: | "MauMau" <maumau307(at)gmail(dot)com> |
|---|---|
| To: | "Soroosh Sardari" <soroosh(dot)sardari(at)gmail(dot)com>, "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pgsql_tmp and external sort |
| Date: | 2013-07-02 10:33:08 |
| Message-ID: | EE2BE9C0CF8E458ABFF084EE88AA15D0@maumau |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
From: "Soroosh Sardari" <soroosh(dot)sardari(at)gmail(dot)com>
> I wonder if anyone could help me to find the module of pg that is
> responsible for the temporal space and external sort in the PG source
> code.
See src/backend/utils/sort/ for sort implementation.
That uses BufFile in src/backend/storage/file/buffile.c,
which in turn uses OpenTemporaryFile in src/backend/storage/file/fd.c.
Regards
MauMau