On 27 May 2015 at 06:52, Medhavi Mahansaria <medhavi.mahansa...@tcs.com> 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/ <http://www.2ndquadrant.com/> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services