Tom Lane wrote:
> However, assuming you've gotten that detail right, then any file
> you can't match up with a relfilenode value must be an orphan you
> can just "rm".
Maybe look in pg_buffercache for entries referencing those files before
deleting. It would be surprising to see any if no catalog points to
those files, but who knows ... If you break checkpointing, you're not
going to be pleased.
If it turns out that a shared buffer exists for any of those files, what
would be a way to evict them without pain?
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
