Re: [GENERAL] abnormal data grow

[Reynard Hilman]

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 


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])