| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Bill Moran" <wmoran(at)collaborativefusion(dot)com> |
| Cc: | <hackers(at)postgresql(dot)org> |
| Subject: | Re: Logging temp file useage ... a little advice wouldbe appreciated |
| Date: | 2006-12-29 23:42:19 |
| Message-ID: | 1167435740.3903.306.camel@silverbirch.site |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 2006-12-29 at 17:53 -0500, Bill Moran wrote:
> So I've got this patch (attached, against 8.2)
>
> The goal is to track temp file usage as an aid to server tuning (such as
> work_mem)
>
> Most of the patch seems to work just dandy, except I'm getting weird
> sizes reported:
>
> 2006-12-29 17:46:21 EST [45558]: [575-1] LOG: temp file: size 140737488343776 path base/32861/pgsql_tmp/pgsql_tmp45558.554
>
> Seems a bit odd to have a 140T file on a 130G partition ...
The fd can be set to VFD_CLOSED just above where you've patched.
Try stat-ing the filename instead, as the unlink does.
Your patches should be diff -c format, submitted to -patches, please.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2006-12-29 23:54:20 | Re: psql possible TODO |
| Previous Message | Jaime Casanova | 2006-12-29 23:42:10 | Re: Deadline-Based Vacuum Delay |