Re: Removal of temp tables

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Removal of temp tables
Date: 2001-06-14 19:46:41
Message-ID: 200106141946.f5EJkf819021@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> You had that to begin with, and I changed it because I thought it was a
> bad idea. The directory name and file name should both make perfectly
> clear that the files are temp files belonging to Postgres. For example,
> it would be unsafe to make pg_tempfiles be a symlink pointing to a temp
> directory shared with other apps if there was any risk of temp file name
> collisions. (Not sure you'd do that anyway, because of security issues,
> but let's not foreclose it with a poor choice of file names.) A purely
> numeric file name for temp files is a particularly bad idea because it
> looks too much like our numeric names for table data files. Don't
> eliminate a hypothetical confusion factor between relnames and filenames
> (which are never seen in the same context anyway) by introducing one
> between filenames and other filenames.
>
> If you don't like pg_temp here, maybe post_temp? pgsql_temp?

What if I call the directory tmp or pgsql_tmp and the files
pgsql_pid_#.#?

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Myers 2001-06-14 19:57:13 Re: What (not) to do in signal handlers
Previous Message Tom Lane 2001-06-14 18:18:40 Re: What (not) to do in signal handlers

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-06-14 20:15:03 Re: Removal of temp tables
Previous Message Bruce Momjian 2001-06-14 18:18:29 Re: Removal of temp tables