slow cursor - Mailing list pgsql-performance

From Sriram Dandapani
Subject slow cursor
Date
Msg-id 6992E470F12A444BB787B5C937B9D4DF0406A546@ca-mail1.cis.local
Whole thread Raw
Responses Re: slow cursor  (Luckys <plpgsql@gmail.com>)
List pgsql-performance

Hi

 

I have a cursor that fetches 150K rows and updates or inserts a table with 150K rows.

 

It takes several minutes for the process to complete (about 15 minutes). The select by itself (without cursor) gets all rows in 15 seconds.

 

Is there a way to optimize the cursor to fetch all records and speed up the process. I still need to do the record by record processing

 

pgsql-performance by date:

Previous
From: Christian Storm
Date:
Subject: Re: pgmemcache
Next
From: "Sriram Dandapani"
Date:
Subject: creating of temporary table takes very long