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-08 17:52:22
Message-ID: 1307555359-sup-5257@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 mar jun 07 12:26:34 -0400 2011:

> It's not *that* many levels: in fact, I think md.c is the only level
> that would just have to pass it through without doing anything useful.
> I think that working from there is a saner and more efficient approach
> than what you're sketching.
>
> If you want a concrete design sketch, consider this:

Okay, here's a patch implementing this idea. It seems to work quite
well, and it solves the problem in a limited testing scenario -- I
haven't yet tested on the customer machines.

This customer is running on 8.4 so I started from there; should I
backpatch this to 8.2, or not at all? (I have all the branches ready
anyway.)

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

Attachment Content-Type Size
smgr-transient-files.patch application/octet-stream 8.4 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-06-08 18:28:02 Re: Postmaster holding unlinked files for pg_largeobject table
Previous Message Callum Scott 2011-06-08 17:01:16

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2011-06-08 17:53:12 Re: reducing the overhead of frequent table locks - now, with WIP patch
Previous Message Joshua Berkus 2011-06-08 17:43:29 Re: reducing the overhead of frequent table locks - now, with WIP patch