Terry wrote:
One more question. This is a pretty decent sized table. It is estimated to be 19,038,200 rows. That said, should I see results immediately pouring into the destination table while this is running?
SQL transactions are atomic. you wont' see anything in the 'new' table until the INSERT finishes committing, then you'll see it all at once.
you will see a fair amount of disk write activity while its running. 20M rows will take a while to run the first time, and probably a fair amount of memory.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
