migrating from Postgres to MonetDB

Question

I need to know how to migrate from Postgres to MonetDB. Postgres is getting slow and we are trying to change to Monet. Someone now if already exists a script or another thing to migrate to Monet?

exist something equivalent to plpgsql on MonetDB? exist materialized view on MonetDB?

Are you sure that MonetDB will magically solve all your problems? — Ihor Romanchenko
– Ihor Romanchenko, Commented May 18, 2015 at 15:33
really, I don't think. We are trying others databases. I'm in charge of tests on column based DB and I picked monetDB. — João Manoel
– João Manoel, Commented May 18, 2015 at 16:16
If you want to fix a problem, don't create new problems. What's the performance problem you have? Maybe we can help. — Frank Heikens
– Frank Heikens, Commented May 18, 2015 at 18:33
If you want to test your load on columnar DBs in general - try this one: github.com/citusdata/cstore_fdw It is an extension for postgres to enable columnar stores. In general columnar stores are only good for particular analytical workloads and are horible for general OLTP loads. — Ihor Romanchenko
– Ihor Romanchenko, Commented May 18, 2015 at 19:28
@IgorRomanchenko for the record, monetdb does magically solve all problems. it is a gandalf merlin potter to the millionth power — Anthony Damico
– Anthony Damico, Commented May 20, 2015 at 3:10

mkersten · Accepted Answer · 2015-05-27 22:30:48Z

3

The following booklet may be relevant to quickly identify some syntactic feature differences. https://en.wikibooks.org/wiki/SQL_Dialects_Reference

And the citrus performance is covered in a blogpost https://www.monetdb.org/content/citusdb-postgresql-column-store-vs-monetdb-tpc-h-shootout

answered May 27, 2015 at 22:30

mkersten

7143 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Treycos · Accepted Answer · 2016-10-12 08:26:32Z

1

firstly: You can export data from postgres like:

 psql -h xxxxx -U xx -p xx -d postgres -c "copy (select * from db40.xxx) to '/tmp/xxx.csv' delimiter ';'"

secondly: You must replace the NULL like:

sed 's/\\N/NULL/g' xxx.csv >newxxx.csv

last: You can use this to copy data into monetdb like:

mclient -u monetdb -d voc -h 192.168.205.8 -p 50000 -s "COPY INTO newxxx from '/tmp/newxxx.csv' using delimiters ';';"

edited Oct 12, 2016 at 8:26

Treycos

7,4913 gold badges29 silver badges53 bronze badges

answered Oct 12, 2016 at 8:05

shabao

114 bronze badges

Collectives™ on Stack Overflow

migrating from Postgres to MonetDB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related