[mb-datafeed] TRM tables in replicated data

Robert Kaye rob at eorbit.net
Fri Jun 2 21:44:21 UTC 2006


Hi!

The TRM tables in the Postgres database are growing quite large and  
due to their replicated nature, its difficult to prune out the TRMs  
that have been removed from the actual TRM signature server. This  
means that large chunks of the TRM id table are now meaningless, but  
due to the replicated nature, its nigh impossible to delete the  
missing rows. (its painfully slow)

Given that TRM is going to be phased out soon (due to these types of  
problems) would anyone here mind if we dropped the TRM tables from  
the replication system? This should only affect people who are  
currently using the TRM tables. If you are not using them, then there  
should be no problem. Please speak up in the next week if you have an  
objection to this, otherwise we will start taking steps for dropping  
TRMs from the replicated tables.

Thanks!

--

--ruaok      Somewhere in Texas a village is *still* missing its idiot.

Robert Kaye     --     rob at eorbit.net     --    http://mayhem-chaos.net





More information about the Musicbrainz-datafeed mailing list