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 21:43:27
Message-ID: 1307654519-sup-2207@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 17:10:10 -0400 2011:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> > Excerpts from Alvaro Herrera's message of jue jun 09 16:34:13 -0400 2011:
> >> I have pushed it now.
>
> > ... and it caused a failure on the buildfarm, so I panicked and reverted
> > it. I think the patch below fixes it.
>
> Actually, I think what you want is what closeAllVfds does, which
> suggests that you need a FileIsNotOpen test too.

Yeah, I noticed that my proposed change doesn't solve the problem.

> > Let me know if you think I should push the whole thing again.
>
> Yesterday I would have said okay, but now we're too close to the beta2
> wrap deadline. Please hold off until beta2 is out.

Will do.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Clemens Schwaighofer 2011-06-10 01:05:24 Re: plpgsql function with update and seeing changed data from outside during run
Previous Message Tom Lane 2011-06-09 21:10:10 Re: Postmaster holding unlinked files for pg_largeobject table

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2011-06-09 21:45:40 Re: pgsql: Use "transient" files for blind writes
Previous Message Tom Lane 2011-06-09 21:41:57 Re: tuning autovacuum