Re: Postmaster holding unlinked files for pg_largeobject table

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov>, alexk <alexk(at)commandprompt(dot)com>, Alexander Shulgin <ash(at)commandprompt(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Postmaster holding unlinked files for pg_largeobject table
Date: 2011-06-09 20:02:14
Message-ID: 1307649664-sup-6207@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Excerpts from Tom Lane's message of jue jun 09 14:45:31 -0400 2011:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > Excerpts from Tom Lane's message of mié jun 08 14:28:02 -0400 2011:
> >> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> >>> This customer is running on 8.4 so I started from there; should I
> >>> backpatch this to 8.2, or not at all?
>
> >> I'm not excited about back-patching it...
>
> > Bummer.
>
> Well, of course mine is only one opinion; anybody else feel this *is*
> worth risking a back-patch for?
>
> My thought is that it needs some beta testing. Perhaps it'd be sane to
> push it into beta2 now, and then back-patch sometime after 9.1 final,
> if no problems pop up.

FWIW I was about to push it but noticed that regression tests fail with
this:

TRAP: FailedAssertion("!(!ReindexIsProcessingIndex(((indexRelation)->rd_id)))", File: "/pgsql/source/HEAD/src/backend/access/index/indexam.c", Line: 283)

I just make distclean'd -- still there. I'm gonna revert my patch and
retry.

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2011-06-09 20:34:13 Re: Postmaster holding unlinked files for pg_largeobject table
Previous Message Robert Haas 2011-06-09 19:03:26 Re: Postmaster holding unlinked files for pg_largeobject table

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2011-06-09 20:26:29 pgsql: Use "transient" files for blind writes
Previous Message Kevin Grittner 2011-06-09 19:32:29 Re: could not truncate directory "pg_serial": apparent wraparound