[PATCH] [REVIEW:3-5,3-6] size optimisation

[Miklos Vajna]

On Wed, Jul 04, 2012 at 10:34:36AM +0200, Lionel Elie Mamane <lionel at mamane.lu> wrote:
> Yes, but *which* statement that is depends on the underlying database
> engine. For example:
> 
>  * HSQLDB: "CHECKOPOINT DEFRAG;" will do it on the whole database
> 
>  * MySQL:  "OPTIMIZE TABLE foo, bar, qux;" will do it on tables foo,
>             bar and qux. To do on the whole database, need to list all
> 	    tables.
> 
>  * PostgreSQL: "VACUUM FULL ANALYZE;" will do it on the whole database

Ah, makes sense -- and handling that correctly would indeed require a
new API.