[mythtv-users] Slow MySQL query after delete

David Brodbeck gull at gull.us
Wed Sep 5 16:46:26 UTC 2007

On Sep 5, 2007, at 1:22 AM, David Rees wrote:

> On 9/4/07, David Brodbeck <gull at gull.us> wrote:
>> It's been a long time since I ran a Postgres database, but I  
>> recall having
>> to run a 'vacuum' script on it on a regular basis to keep it running
>> properly.   So, probably six of one, half a dozen of the other.  I  
>> can run
>> VACUUM, or I can run OPTIMIZE TABLE.  I don't really care which it  
>> is.
> No longer needed (most of the time) on recent versions of Postgres if
> you set up the autovacuum daemon. It does it automatically in the
> background for you.

So it's still there, it's just hidden.  I guess if MySQL (or MythTV)  
quietly ran an OPTIMIZE TABLE once a week, instead of my scheduling  
it in cron, people would stop complaining that MySQL is a "toy"  
database -- even though the behavior would be exactly the same. ;)

More information about the mythtv-users mailing list