7

I am testing duckdb database for analytics and I must say is very fast. The issue is the database file is growing and growing but I need to make it small to share it.

In sqlite I recall to use the VACUUM commadn, but here same command is doing nothing. Size is the same.

how to reduce file size for duckdb database?

Forge
  • 1,587
  • 1
  • 15
  • 36
  • Did you ever figure this out? I'm looking for something similar... – HCAI Feb 19 '21 at 21:54
  • 2
    No clue. I exported the complete SQL dump code and then create all database using a different filename. – Forge Feb 20 '21 at 22:43

1 Answers1

7

Seems that this option is not available yet. What I use is EXPORT database command , create a new clean data file and then IMPORT.

Documentation here https://duckdb.org/docs/sql/statements/export

useRj
  • 1,232
  • 1
  • 9
  • 15