Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
