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

Reply via email to