Good morning to you all, I've been migrating MySQL to PostgreSQL data through Pgpool-II Server. I noticed that it's faster to INSERT data directly to the backends most probably due to the overhead. Since I already know where the data should go anyway, is it possible to just INSERT the appropriate sets of data to their respective backend nodes? And if I do that, would Parallel Query Mode still work properly provided that the FUNCTION and dist_def definitions created are correct? And any suggestions on how to make the migration faster because I've been INSERTing data for weeks and been making Pgpool-II Parallel Query Mode work for months already. And lastly, again, when should I use replicate_def in Parallel Mode? Please help me so that I could finish my task and move on to another project. Thank you so much in advance.
Sincerely, Viril Calimlim Research And Development Supervisor IT Department - National Bookstore Data Edge Corporation _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
