Unless you want the table to be named the same as it was before... as far as I am aware there is no support for renaming tables.  Also... COPY INTO seems to be faster than a SELECT into a new table.

73,
Matthew W. Jones (KI4ZIB)
http://matburt.net


On Mon, May 17, 2010 at 10:57 AM, Stefan de Konink <stefan@konink.de> wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Op 17-05-10 16:51, Matthew Jones schreef:
> Another huge issue is that deleting records from a table still won't
> shrink the size of the table.   I like to keep some of my raw data
> tables small so once a day I delete some already processed records out
> of them, dump the table, and then reload it.

Another quicky would be:

start transaction;
drop table activeselecting;
create table activeselecting...
insert into activeselecting select * from alldata;
commit;



Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.15 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEAREKAAYFAkvxWWsACgkQYH1+F2Rqwn1x7ACfUg0LWJsef3ONbxtw9b9NO7RD
Qs0An3EM/jy4E5SftTE+9tvEqnQ0ryMV
=629O
-----END PGP SIGNATURE-----

------------------------------------------------------------------------------

_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users