Re: [PATCHES] pg_autovacuum/Win32 Fixes

2005-01-22 Thread Neil Conway
Dave Page wrote: Theis patch supercedes *all* my earlier ones from today - apologies for the noise, clearly I need a beer or 3 and a few nights away from the laptop. @@ -1166,7 +1166,9 @@ exit(0); #ifdef WIN32 case 'E': - args->service_dependencies = optarg; +

[PATCHES] vacuum hint on elog

2005-01-22 Thread Neil Conway
It occurred to me that if we elog(ERROR) during VACUUM, the vacuum activity hint will not be reset. This will result in all subsequent I/O by the current backend being treated by the bufmgr as though it resulted from VACUUM. While elog(ERROR) during VACUUM is not a common occurrence, I don't th

Re: [PATCHES] vacuum hint on elog

2005-01-22 Thread Alvaro Herrera
On Sat, Jan 22, 2005 at 11:28:52PM +1100, Neil Conway wrote: > It occurred to me that if we elog(ERROR) during VACUUM, the vacuum > activity hint will not be reset. This will result in all subsequent I/O > by the current backend being treated by the bufmgr as though it resulted > from VACUUM. Wh

Re: [PATCHES] vacuum hint on elog

2005-01-22 Thread Neil Conway
Alvaro Herrera wrote: Hmm ... I think you should rather use a PG_TRY/PG_CATCH block. Thanks for the suggestion, Alvaro -- I think that's a better way to go. It means we can keep vacuum-specific stuff in vacuum.c, rather than adding to AbortTransaction(). I'll post a revised patch tomorrow. While

Re: [PATCHES] pg_autovacuum/Win32 Fixes

2005-01-22 Thread Dave Page
> -Original Message- > From: Neil Conway [mailto:[EMAIL PROTECTED] > Sent: 22 January 2005 10:13 > To: Dave Page > Cc: pgsql-patches@postgresql.org > Subject: Re: [PATCHES] pg_autovacuum/Win32 Fixes > > Dave Page wrote: > > Theis patch supercedes *all* my earlier ones from today - > a

Re: [PATCHES] vacuum hint on elog

2005-01-22 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > It occurred to me that if we elog(ERROR) during VACUUM, the vacuum > activity hint will not be reset. The code beginning at freelist.c line 645 is intended to deal with this. > Attached is a patch which resets the vacuum activity hint in > AbortTransact

Re: [PATCHES] [DOCS] bug in 8.0 manual, section 37.6, PL/Perl Triggers

2005-01-22 Thread Bruce Momjian
Rainer Brandt wrote: > Hi, > > All places that mention the trigger event info hash pointer $_TD > end with the "->" characters. The hash keys are omitted. > That is certainly not what you wanted. > (Also, the code examples will not compile under Perl. (I didn't > try, but can see that they won't

Re: [PATCHES] [pgsql-hackers-win32] pg_autovacuum fails to start - 8.0 Release

2005-01-22 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Da

Re: [PATCHES] [pgsql-hackers-win32] pg_autovacuum fails to start - 8.0

2005-01-22 Thread Bruce Momjian
[ Old version superceeded.] Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --

Re: [PATCHES] vacuum hint on elog

2005-01-22 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> The code beginning at freelist.c line 645 is intended to deal with this. > Ah, good point -- sorry, I missed that. The code as-is should be fine, then. Well, one point is that the flag bit is checked elsewhere in the same file without s

Re: [PATCHES] vacuum hint on elog

2005-01-22 Thread Neil Conway
Tom Lane wrote: The code beginning at freelist.c line 645 is intended to deal with this. Ah, good point -- sorry, I missed that. The code as-is should be fine, then. -Neil ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unre

Re: [PATCHES] uptime function to postmaster

2005-01-22 Thread Bruce Momjian
This has been saved for the 8.1 release: http://momjian.postgresql.org/cgi-bin/pgpatches2 --- Euler Taveira de Oliveira wrote: > > Bruce Momjian wrote: > > > > This has been saved for the 8.1 release: > > > >