Migration from plain PostgreSQL to Citus

46 views

Skip to first unread message

Pablo S

unread,

Dec 23, 2020, 5:57:57 PM12/23/20

to citus-users

I have a PostgreSQL 12 database and need to migrate to Citus cstore_fdw, converting the tables from row-oriented to columnar. What is the best approach to do this? Will a dump/restore create columnar tables? Is this something that needs to be done manually with scripts (first create empty columnar tables in Citus and then run a script with inserts)?

Halil Ozan Akgül

unread,

Jan 4, 2021, 6:57:32 AM1/4/21

to citus-users

Hey, just to make sure, are you trying to only use columnar storage or are you also trying to migrate to Citus too?

I mean do you plan to distribute your cstore tables?

24 Aralık 2020 Perşembe tarihinde saat 01:57:57 UTC+3 itibarıyla Pablo S şunları yazdı:

Reply all

Reply to author

Forward

0 new messages