>>Is that file still in used (because I can't find it in the pg_class
>>table)?
>>
>>
>Yes. Don't delete it manually.
>
>
Thanks for that advice :) I wasn't really going to delete it, just
tempted to.
following Tom's advice, this query:
select relname from pg_class where relfilenode = 25677563;
returns pg_toast_25677561 which is the record in pg_class that has the biggest relpages, so that makes sense.
I'll try running reindex tonight then, hopefully that does some clean up.
thanks for all the advice,
- reynard
