On 27 May 2015 at 06:52, Medhavi Mahansaria <medhavi.mahansaria@xxxxxxx> wrote:
--
We are using bulk collect to enhance the performance as the data is huge.
Using BULK COLLECT speeds up retrieving rows into memory, but if the data is huge that wasn't a great plan anyway, so doing it faster doesn't matter much.
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
