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
