Re: vacuum as flags in PGPROC

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: vacuum as flags in PGPROC
Date: 2007-10-24 22:00:15
Message-ID: 15765.1193263215@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Also, I forgot to mention it on the first email, but this patch adds
> errcontext() lines when an autovacuum/analyze is being aborted. It
> works fine, but I'm not seeing code anywhere else that does something
> like this.

This is a little bit scary because you might be invoking system catalog
reads after the transaction has already failed. What would it take to
save the names involved before starting the TRY block? I'm not worried
about the errcontext() call per se, only about the syscache fetches.

regards, tom lane

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2007-10-25 02:26:16 Re: Crosstab Problems
Previous Message Bruce Momjian 2007-10-24 17:01:32 Re: [HACKERS] Including Snapshot Info with Indexes