Обсуждение: Problem with sql

Поиск
Список
Период
Сортировка

Problem with sql

От
"De Leeuw Guy"
Дата:
Hello everybody,

I running Postgres on a AIX 4.3.3 system, and have encountered an error
to be a communication problem between the backend and the frontend when
making a query on a approximately 66Mb return result.
The error returned is :
"Backend Sent D message without Prior T"

With about 31 Mb no problems !

It is a congiguration options ?

Thanks in advance,

Guy


Re: Problem with sql

От
Tom Lane
Дата:
"De Leeuw Guy" <G.De_Leeuw@eurofer.be> writes:
> I running Postgres on a AIX 4.3.3 system, and have encountered an error
> to be a communication problem between the backend and the frontend when
> making a query on a approximately 66Mb return result.
> The error returned is :
> "Backend Sent D message without Prior T"

libpq is running out of memory to store the query result.  It does not
handle that very gracefully :-(

            regards, tom lane