This helped, is now down from 14.9 min to 10.9 min to run the entire script. Thanks.
>>>>Dne 17.3.2011 19:29, Davenport, Julie napsal(a): >>>> I have not yet had time to try Tomas' suggestion of bumping up the >>>> work_mem first (trying to >>>>figure out how to do that from within a >>>> coldfusion script). Many thanks for all your help guys! >>Well, just execute this 'SQL query' just like the other ones >>set work_mem='8MB' >>and it will increase the amount of memory for that connection. >>Tomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
