Re: Postmaster holding unlinked files for pg_largeobject table

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Alexander Shulgin <ash@commandprompt.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, alexk <alexk@commandprompt.com>
Date: 2011-06-04T16:49:05Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Reset reindex-in-progress state before reverifying an exclusion constraint.

Alvaro Herrera <alvherre@commandprompt.com> writes:
> What surprises me is that the open references remain after a database
> drop.  Surely this means that no backends keep open file descriptors to
> any table in that database, because there are no connections.

bgwriter ...

			regards, tom lane