Re: Postgres eats up memory when using cursors - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgres eats up memory when using cursors
Date
Msg-id 21121.983460832@sss.pgh.pa.us
Whole thread Raw
In response to Postgres eats up memory when using cursors  (Denis Perchine <dyp@perchine.com>)
Responses Re: Postgres eats up memory when using cursors  (Denis Perchine <dyp@perchine.com>)
List pgsql-general
Denis Perchine <dyp@perchine.com> writes:
> I declare a cursor on the table of approx. 1 million rows.
> And start fetching data by 1000 rows at each fetch.
> Data processing can take quite a long time (3-4 days)
> Theoretically postgres process should remain the same in size.
> But it grows... In the end of 3rd day it becames 256Mb large!!!!

Query details please?  You can't expect any results from such a
vague report.

            regards, tom lane

pgsql-general by date:

Previous
From: "chris markiewicz"
Date:
Subject: database diff
Next
From: DaVinci
Date:
Subject: JOIN of a table with many detail tables