On 3/5/16, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote: > > I have a question, is it enough to vacuum a database to update to the new > page size ?
The new page size only applies to newly created database files. VACUUM-ing an existing database file will not change its page size. However, if you say "PRAGMA page_size=N; VACUUM;" (for some N) that will change the page size if you are not in WAL mode. > > Also I have a database not too big 6GB but only 12GB free space on that > disk, > if I try a dump/restore with the actual sqlite3 maybe I'll run out of disk > space, there is any chance to have compressed backup/restore ? You'll probably run out of space if you try to VACUUM. 12GB isn't very much. USB thumb-drives are usually bigger than that. You can't get better hardware? > > Also PostgreSQL have different options for backup/restore like using the > "COPY" command (databases dumped using COPY have smaller dumps). > SQLite version 2 supported COPY. That was dropped when we moved to SQLite 3. -- D. Richard Hipp drh at sqlite.org