Re: abnormal data grow

>>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