Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Logging temp file useage ... a little advice wouldbe appreciated
- 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: Fri, 29 Dec 2006 23:42:19 +0000
- Message-id: <1167435740.3903.306.camel@silverbirch.site> <text/plain>
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
- References:
- Logging temp file useage ... a little advice would be appreciated
- From: Bill Moran
- Logging temp file useage ... a little advice would be appreciated
- Prev by Date: Re: Deadline-Based Vacuum Delay
- Next by Date: Re: psql possible TODO
- Previous by thread: Logging temp file useage ... a little advice would be appreciated
- Next by thread: Re: Logging temp file useage ... a little advice
- Indexes: