Re: [MonetDB-users] MonetDB performance

17 May 2010

      On Mon, May 17, 2010 at 11:15:49AM -0400, Matthew Jones wrote:
...
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.
Is also DUMP + COPY INTO faster than SELECT into a new table
(or, say, CREATE TABLE <new> AS SELECT ... FROM TABLE <old> ... WITH DATA;)?

In either case, that's "interesting" and unexpected to me --- I'll try to
investigate later this week ...

Stefan
...
73,
Matthew W. Jones (KI4ZIB)
http://matburt.net
On Mon, May 17, 2010 at 10:57 AM, Stefan de Konink  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

...
------------------------------------------------------------------------------

...
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- 
| Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl |
| CWI,  P.O.Box 94079 | http://www.cwi.nl/~manegold/  |
| 1090 GB Amsterdam   | Tel.: +31 (20) 592-4212       |
| The Netherlands     | Fax : +31 (20) 592-4199       |