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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
