> What's the file's size now?

After VACUUM it is 2.0 GB now.

Still? Wow.

 > BTW: in 7.9 auto_vacuum should be on by default. But it seems this
 > doesn't work. I'll have to investigate this further.

Perhaps this is a session setting, so that it is set within LMS but not
for other clients like sqlite3 cmdline tool?

No, it's one of the things you even have to define before almost anything else: the reason why it didn't work was that I only defined it after some of the other parameters. Now I've put it really first thing after creating the db file.

"...auto-vacuuming must be turned on before any tables are created. It is not possible to enable or disable auto-vacuum after a table has been created."

--

Michael
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta

Reply via email to