[PATCHES] Patch to bring \copy syntax more in line with SQL copy

2004-01-17 Thread Bill Moran
of src/bin/psql/copy.c The resulting psql binary (based off a cvsup from HEAD on 1/18) compiles and works for me on FreeBSD 5.1. -- Bill Moran Potential Technologies http://www.potentialtech.com *** copy.c.old Sat Jan 17 22:17:58 2004 --- copy.c Sat Jan 17 23:06:30 2004 *** *** 226,

Re: [PATCHES] Patch to bring \copy syntax more in line with SQL copy

2004-01-20 Thread Bill Moran
nd. If there's docs that need updated, please point me specifically to them and I'll be happy to generate a patch to the best of my ability. - update the comment at the top of copy.c Oops ... got it. Bill Moran <[EMAIL PROTECTED]> writes: Ideally, this should cover all cases of ol

[update] Re: [PATCHES] Patch to bring \copy syntax more in line with SQL copy

2004-01-25 Thread Bill Moran
27;s probably right. Both patches are against the most recent versions in CVS at the time of diffing. Bill Moran wrote: Neil Conway wrote: A few quick comments: - don't use C++-style comments Oops ... sorry ... been doing too much PHP. BTW: Why is this frowned apon so? Are there compil

[PATCHES] Patch to log usage of temporary files

2007-01-02 Thread Bill Moran
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

Re: [PATCHES] Patch to log usage of temporary files

2007-01-02 Thread Bill Moran
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 suggesti

Re: [HACKERS] [PATCHES] Patch to log usage of temporary files

2007-01-03 Thread Bill Moran
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 sav

Re: [HACKERS] [PATCHES] Patch to log usage of temporary files

2007-01-03 Thread Bill Moran
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

Re: [HACKERS] [PATCHES] Patch to log usage of temporary files

2007-01-04 Thread Bill Moran
In response to "Andrew Dunstan" <[EMAIL PROTECTED]>: > Bill Moran wrote: > > Andrew Dunstan <[EMAIL PROTECTED]> wrote: > >> > >> Bill Moran wrote: > >> > +if (trace_temp_files != -1) > >> > >

Re: [HACKERS] [PATCHES] Patch to log usage of temporary files

2007-01-04 Thread Bill Moran
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 confi

Re: [HACKERS] [PATCHES] Patch to log usage of temporary files

2007-01-09 Thread Bill Moran
pens > at file deletion time. Thanks. -- 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

Re: [HACKERS] [PATCHES] Patch to log usage of temporary files

2007-01-09 Thread Bill Moran
d this devilish master plan that - values would be less than and positive values greater than, then I decided I was being stupid. So, that's my input. But, at this point I'm not entirely sure what the best approach is. -- Bill Moran Collaborative Fusion Inc. -

Re: [pgsql-patches] [PATCHES] Patch to log usage of temporary files

2007-01-12 Thread Bill Moran
suspect are causing unwarranted temp files on a production server, I can enable it on a per-connection basis to track down the problem and work on a specific query, on production systems, without too much disruption of the rest of the work that's going on: set log_temp_files = 0; se

Re: [PATCHES] log_autovacuum

2007-04-17 Thread Bill Moran
; > Would it work to add a separate GUC var to control the minimum autovac > time? Also, why do it by time and not by amount of tuples/pages > removed? When I submitted the log_temp_files stuff, there was considerable discussion on the topic of how the GUC vars should be done. IIRC, t