on the topic of how the GUC vars should be done. IIRC, the
eventual decision was to have a single GUC var, where -1 equated to
off, 0 equated to log all, and numbers higher than 0 were a size limit
on when things get logged.
--
Bill Moran
Collaborative Fusion Inc.
http
query, on production systems, without too much
disruption of the rest of the work that's going on:
set log_temp_files = 0;
run suspect query
set log_temp_files = -1;
investigate logs
At least, those are my current plans ...
--
Bill Moran
Collaborative Fusion Inc
.
--
Bill Moran
Collaborative Fusion Inc.
---(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
. But, at this point I'm not entirely sure what the
best approach is.
--
Bill Moran
Collaborative Fusion Inc.
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
In response to Andrew Dunstan [EMAIL PROTECTED]:
Bill Moran wrote:
Andrew Dunstan [EMAIL PROTECTED] wrote:
Bill Moran wrote:
+if (trace_temp_files != -1)
Might be more robust to say
if (trace_temp_files = 0)
Because it would allow for the easy addition
In response to Tom Lane [EMAIL PROTECTED]:
Bill Moran [EMAIL PROTECTED] writes:
Andrew Dunstan [EMAIL PROTECTED] wrote:
Might be more robust to say
if (trace_temp_files = 0)
I specified in the GUC config that minimum allowable value is -1.
I'd still tend to go with Andrew's
In response to Simon Riggs [EMAIL PROTECTED]:
On Tue, 2007-01-02 at 18:20 -0500, Tom Lane wrote:
Bill Moran [EMAIL PROTECTED] writes:
In response to Alvaro Herrera [EMAIL PROTECTED]:
Please change things to save the stat() syscall when the feature is not
in use.
Do you have
Andrew Dunstan [EMAIL PROTECTED] wrote:
Bill Moran wrote:
+ if (trace_temp_files != -1)
Might be more robust to say
if (trace_temp_files = 0)
Because it would allow for the easy addition of more negative numbers
with magic value?
---(end
Thanks to Simon Riggs and Bruce for input that helped me put this together.
--
Bill Moran
Collaborative Fusion Inc.
diff -c -r src.orig/backend/storage/file/fd.c src/backend/storage/file/fd.c
*** src.orig/backend/storage/file/fd.c Thu Dec 7 15:44:42 2006
--- src/backend/storage/file/fd.c Tue
In response to Alvaro Herrera [EMAIL PROTECTED]:
Bill Moran wrote:
Thanks to Simon Riggs and Bruce for input that helped me put this together.
Please change things to save the stat() syscall when the feature is not
in use.
Do you have a suggestion on how to do that and still have
10 matches
Mail list logo