Re: BUG #1756: PQexec eats huge amounts of memory

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: BUG #1756: PQexec eats huge amounts of memory
Дата
Msg-id 42CD4783.80303@hogranch.com
обсуждение исходный текст
Ответ на Re: BUG #1756: PQexec eats huge amounts of memory  (Neil Conway <neilc@samurai.com>)
Ответы Re: BUG #1756: PQexec eats huge amounts of memory  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-bugs
Neil Conway wrote:
> Denis Vlasenko wrote:
>
>> The same php script but done against Oracle does not have this
>> behaviour.
>
>
> Perhaps; presumably Oracle is essentially creating a cursor for you
> behind the scenes. libpq does not attempt to do this automatically; if
> you need a cursor, you can create one by hand.

I do not understand how a cursor could be autocreated by a query like

    $result = pg_query($db, "SELECT * FROM big_table");

php will expect $result to contain the entire table (yuck!).

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #1759: domain check constraint ignored in prepared statement
Следующее
От: Hans-Jürgen Schönig
Дата:
Сообщение: Re: Sun inline assembler ...