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
-----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