Re: [sqlite] VACUUM requires 6.7 times space ?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/05/2015 10:25 AM, Jim Wilcoxson wrote: > It's easy to do this in Python using iterdump(), Be aware that the pysqlite dump implementation is incomplete in many ways. Some issues: - - Doesn't dump in a transaction so will have irregularities if

Re: [sqlite] VACUUM requires 6.7 times space ?

On Jan 5, 2015, at 5:03 PM, Eduardo Morras wrote: > On Mon, 5 Jan 2015 14:42:28 -0600 > Jay Kreibich wrote: > >> >> >> On Jan 5, 2015, at 12:25 PM, Jim Wilcoxson wrote: >> >>> Simon - instead of using vacuum, it's much faster to create

Re: [sqlite] VACUUM requires 6.7 times space ?

On Mon, 5 Jan 2015 14:42:28 -0600 Jay Kreibich wrote: > > > On Jan 5, 2015, at 12:25 PM, Jim Wilcoxson wrote: > > > Simon - instead of using vacuum, it's much faster to create a new > > database from the old one, then rename it. It's easy to do this in > >

Re: [sqlite] VACUUM requires 6.7 times space ?

On Jan 5, 2015, at 12:25 PM, Jim Wilcoxson wrote: > Simon - instead of using vacuum, it's much faster to create a new > database from the old one, then rename it. It's easy to do this in > Python using iterdump(), or you can connect to the new (empty) > database, do your

[sqlite] VACUUM requires 6.7 times space ?

Simon - instead of using vacuum, it's much faster to create a new database from the old one, then rename it. It's easy to do this in Python using iterdump(), or you can connect to the new (empty) database, do your create table statements, attach the old database as olddb, then do: insert into

Re: [sqlite] VACUUM requires 6.7 times space ?

On Jan 5, 2015, at 8:43 AM, Nelson, Erik - 2 wrote: > RSmith wrote on Monday, January 05, 2015 7:43 AM >> >> >>> On 01/05/2015 06:22 PM, Simon Slavin wrote: I have a database file which is 120GB in size. It consists of two huge tables and an

Re: [sqlite] VACUUM requires 6.7 times space ?

Simon Slavin wrote on Monday, January 05, 2015 10:40 AM > > On 5 Jan 2015, at 2:43pm, Nelson, Erik - 2 > wrote: > > > RSmith wrote on Monday, January 05, 2015 7:43 AM > > > >> I haven't done this, but I seem to remember there was a way to tell > >> SQLite where

Re: [sqlite] VACUUM requires 6.7 times space ?

On 5 Jan 2015, at 2:43pm, Nelson, Erik - 2 wrote: > RSmith wrote on Monday, January 05, 2015 7:43 AM > >> I haven't done this, but I seem to remember there was a way to tell >> SQLite where to make temp files, or override the system default at any >> rate -

Re: [sqlite] VACUUM requires 6.7 times space ?

RSmith wrote on Monday, January 05, 2015 7:43 AM > > On 2015/01/05 13:32, Dan Kennedy wrote: > > On 01/05/2015 06:22 PM, Simon Slavin wrote: > >> I have a database file which is 120GB in size. It consists of two > huge tables and an index. //... > > Probably running out of space wherever temp

Re: [sqlite] VACUUM requires 6.7 times space ?

On 2015/01/05 13:32, Dan Kennedy wrote: On 01/05/2015 06:22 PM, Simon Slavin wrote: I have a database file which is 120GB in size. It consists of two huge tables and an index. //... Probably running out of space wherever temp files are created. I haven't done this, but I seem to remember

Re: [sqlite] VACUUM requires 6.7 times space ?

On 5 Jan 2015, at 11:32am, Dan Kennedy wrote: > Probably running out of space wherever temp files are created. Oh, that makes a lot of sense. The free space on the boot volume for that system is only 37GB. Okay, I can move the file to another computer. Thanks for the

Re: [sqlite] VACUUM requires 6.7 times space ?

Hi, Simon, On Mon, Jan 5, 2015 at 6:32 AM, Dan Kennedy wrote: > On 01/05/2015 06:22 PM, Simon Slavin wrote: >> >> I have a database file which is 120GB in size. It consists of two huge >> tables and an index. >> Its journal_mode is DELETE. >> >> It is on a partition with

Re: [sqlite] VACUUM requires 6.7 times space ?

On 01/05/2015 06:22 PM, Simon Slavin wrote: I have a database file which is 120GB in size. It consists of two huge tables and an index. Its journal_mode is DELETE. It is on a partition with 803GB of free space. By my calculations I have 6.7 times the amount of free space as the database is

[sqlite] VACUUM requires 6.7 times space ?

I have a database file which is 120GB in size. It consists of two huge tables and an index. Its journal_mode is DELETE. It is on a partition with 803GB of free space. By my calculations I have 6.7 times the amount of free space as the database is taking up. I use the SQLite shell tool