Postgres Pro
Downloads
Home   >   mailing lists

Re: Reg: BULK COLLECT - Mailing list pgsql-general

From Simon Riggs
Subject Re: Reg: BULK COLLECT
Date
Msg-id CANP8+j+rLbQBdMnt61MOPeCfZoKUCm1QPZU1KrhmahdbxNqERw@mail.gmail.com
Whole thread Raw
In response to Re: Reg: BULK COLLECT  (Medhavi Mahansaria <medhavi.mahansaria@tcs.com>)
List pgsql-general
Tree view
On 27 May 2015 at 06:52, Medhavi Mahansaria <medhavi.mahansaria@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/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: duplicate key value violates unique constraint "pg_class_relname_nsp_index"
Next
From: Steve Kehlet
Date:
Subject: Re: delaying autovacuum freeze via storage params?