Re: [GENERAL] Postgres eats up memory when using cursors

[Tom Lane]

Denis Perchine <[EMAIL PROTECTED]> 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