Re: [HACKERS] Last infomask bit - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: [HACKERS] Last infomask bit
Date
Msg-id 200701092244.l09MifO00861@momjian.us
Whole thread Raw
In response to Re: [HACKERS] Last infomask bit  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
>
> > SHOW ALL has:
>
> >    log_temp_files                  | -1                             | Log the use of temporary files larger than th
>
> Yeah, but if you do "SET log_temp_files = -1", does it still say that?
> I'm worried that will change it to -1024.

You can rest easy tonight.  :-)

    test=> SET log_temp_files = -1;
    SET
    test=> SHOW log_temp_files;
     log_temp_files
    ----------------
     -1
    (1 row)

    test=> SET log_temp_files = 1;
    SET
    test=> SHOW log_temp_files;
     log_temp_files
    ----------------
     1kB
    (1 row)

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Last infomask bit
Next
From: Albert Cervera Areny
Date:
Subject: Re: Tablespace for temporary objects and sort files