Are queries run completely before a Cursor can be used?
От | Seref Arikan |
---|---|
Тема | Are queries run completely before a Cursor can be used? |
Дата | |
Msg-id | CA+4Thdo7HRrW62F6f69Na7xLxEqqXxLHuCA_-f5ircNiW4aVFw@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Are queries run completely before a Cursor can be used?
|
Список | pgsql-general |
Greetings,
The documentation for Cursors at http://www.postgresql.org/docs/9.2/static/plpgsql-cursors.html says that:"Rather than executing a whole query at once, it is possible to set up a cursor that encapsulates the query, and then read the query result a few rows at a time. One reason for doing this is to avoid memory overrun when the result contains a large number of rows"
Is this how cursors work internally? I can't imagine the complexity of managing cursor operations in anything other than extremely simple sql queries.
Any comments and/or pointers to documentation which explains this would be much appreciated.
Best regards
Seref
Best regards
Seref
В списке pgsql-general по дате отправления: