Rakesh: On Tue, Oct 11, 2016 at 9:00 PM, Rakesh Kumar <rakeshkumar464@xxxxxxxxxxx> wrote: >>Cores do not help, postgres is single-threaded. RAM MAY help, but I > I hope this is no longer true from 9.6 for those queries where PG can use parallelism. It does, AFAIK, but for queries, not AFAIK for this kind of data moving ops ( and I doubt it will, as presently you can easily saturate the channels with a single core for that kind of simple ops, and normally if you want to optimize this kind of op is better to target concurrency ( table can be used while moving ) than pure speed . Francisco Olarte. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
