Hi Björn, On Wed, 13 Feb 2019 22:00:06 +0100 Björn Höfling <bjoern.hoefl...@bjoernhoefling.de> wrote:
> I'm not sure if anybody else responded to you, but I have a database > around. I got it last year from Clement Lassieur. It is 1.6 GB in size, > I made a tar.xz an that is only 86 MB! I wonder if there is anything > wrong or it is just thaaat compressible! I think we didn't set up the infrastructure to VACUUM the database. The default in sqlite is not to VACUUM ever, so we probably should either stop the entire thing and vacuum it once a week or we could set up autovacuum to incremental or full (the latter would vacuum at each commit) if we ever ran out of space.
pgpuCEjhSwAke.pgp
Description: OpenPGP digital signature
