From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-06 16:04:51 |
Message-ID: | 1307376189-sup-3066@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Excerpts from Kevin Grittner's message of lun jun 06 11:58:51 -0400 2011:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
>
> > What we found out after more careful investigation is that the
> > file is kept open by a backend connected to a different database.
> > I have a suspicion that what happened here is that this backend
> > was forced to flush out a page from shared buffers to read some
> > other page; and it was forced to do a fsync of this file. And
> > then it forgets to close the file descriptor.
>
> This sounds vaguely similar to what I found with WAL files being
> held open for days after they were deleted by read-only backends:
>
> http://archives.postgresql.org/message-id/15412.1259630304@sss.pgh.pa.us
>
> I mention it only because there might be one place to fix both....
Hmm interesting. I don't think the placement suggested by Tom would be
useful, because the Zabbix backends are particularly busy all the time,
so they wouldn't run ProcessCatchupEvent at all.
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-06-06 16:10:24 | Re: Postmaster holding unlinked files for pg_largeobject table |
Previous Message | Kevin Grittner | 2011-06-06 15:58:51 | Re: Postmaster holding unlinked files for pg_largeobject table |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-06-06 16:10:24 | Re: Postmaster holding unlinked files for pg_largeobject table |
Previous Message | Kevin Grittner | 2011-06-06 15:58:51 | Re: Postmaster holding unlinked files for pg_largeobject table |