Re: [PATCHES] Is autovacuum doing a wraparound-avoiding VACUUM?

2008-07-17 Thread Tom Lane
Simon Riggs <[EMAIL PROTECTED]> writes: > On Thu, 2008-07-17 at 17:10 -0400, Alvaro Herrera wrote: >> I don't like your wording though; it feels too verbose (and you're >> losing the ANALYZE in case it's doing both things). How about >> >> snprintf(activity, MAX_AUTOVAC_ACTIV_LEN, >> "autovacuum

Re: [PATCHES] WITH RECUSIVE patches 0717

2008-07-17 Thread Tatsuo Ishii
> > Here is the lastest WITH RECURSIVE patches against CVS HEAD created by > > Yoshiyuki Asaba and minor corrections by Tatsuo Ishii. > > I tried this patch vs. CVS HEAD used my usual configure option with > only --with-prefix set, then tried to make, and got: > > make[3]: *** No rule to make tar

Re: [PATCHES] Is autovacuum doing a wraparound-avoiding VACUUM?

2008-07-17 Thread Simon Riggs
On Thu, 2008-07-17 at 17:10 -0400, Alvaro Herrera wrote: > Simon Riggs wrote: > > > > Is autovacuum doing a wraparound-avoiding VACUUM? > > Currently, no easy way to tell. > > > > Patch to change message of autovac in pg_stat_activity when we are > > performing an anti-wraparound VACUUM. > > I

Re: [PATCHES] Is autovacuum doing a wraparound-avoiding VACUUM?

2008-07-17 Thread Alvaro Herrera
Simon Riggs wrote: > > Is autovacuum doing a wraparound-avoiding VACUUM? > Currently, no easy way to tell. > > Patch to change message of autovac in pg_stat_activity when we are > performing an anti-wraparound VACUUM. I just obsoleted this patch. The new patch should be easier to do though -- j

Re: [PATCHES] WITH RECUSIVE patches 0717

2008-07-17 Thread David Fetter
On Thu, Jul 17, 2008 at 06:40:25PM +0900, Tatsuo Ishii wrote: > Hi, > > Here is the lastest WITH RECURSIVE patches against CVS HEAD created by > Yoshiyuki Asaba and minor corrections by Tatsuo Ishii. I tried this patch vs. CVS HEAD used my usual configure option with only --with-prefix set, then

[PATCHES] WITH RECUSIVE patches 0717

2008-07-17 Thread Tatsuo Ishii
Hi, Here is the lastest WITH RECURSIVE patches against CVS HEAD created by Yoshiyuki Asaba and minor corrections by Tatsuo Ishii. (David Fetter's psql help patches are not included. It seems his git repository has gone). This version implements: - detect certain queries those are not valid acrod

Re: [PATCHES] [HACKERS] WITH RECURSIVE updated to CVS TIP

2008-07-17 Thread Tatsuo Ishii
> On Wed, Jul 16, 2008 at 01:57:04PM +0900, Tatsuo Ishii wrote: > > > > No idea. What do you think if we allow only one query name at the > > > > moment. > > > > > > I'm not sure I understand what that has to do with sorting. > > > > > > Please find attached a place where I've found some problem