| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
| Cc: | "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Patch to log usage of temporary files |
| Date: | 2007-01-05 21:49:05 |
| Message-ID: | 82EE7695-4354-467A-9BC3-33AFB4B12C7E@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On Jan 3, 2007, at 4:20 PM, Bill Moran wrote:
> * trace_temp_files is now an int: -1 disables, 0 and up equate to
> "log if
> the file is this size or larger"
Another thought is to allow ignoring files over a certain size. The
reason is that if you end up creating 10MB of temp files, you can
probably avoid that by adjusting work_mem. But if you just created
10GB, you probably have no choice in the matter.
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Kaltenbrunner | 2007-01-05 22:20:49 | Re: [COMMITTERS] pgsql: Stamp major release 8.3.0, and increment |
| Previous Message | Jim Nasby | 2007-01-05 21:44:27 | Re: Dead Space Map for vacuum |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albert Cervera Areny | 2007-01-06 00:11:59 | Re: Tablespace for temporary objects and sort files |
| Previous Message | Jim Nasby | 2007-01-05 21:41:01 | Re: [HACKERS] wal_checksum = on (default) | off |