| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | Daniel Farina <daniel(at)fdr(dot)io>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Extra files in "base" dir not seen in relfilenodes |
| Date: | 2018-01-17 17:35:43 |
| Message-ID: | 9188.1516210543@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> 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.
Even if there are any such entries, surely they ought to be clean by
now and thus not a hazard. Not that a manual "CHECKPOINT" might not
be a good idea.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Jones | 2018-01-17 18:51:53 | Possible hang in 10.1 with JSON query over partially indexed partitions |
| Previous Message | Alvaro Herrera | 2018-01-17 17:23:01 | Re: Extra files in "base" dir not seen in relfilenodes |