Re: Max query limit in 7.1? With TOAST?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Max query limit in 7.1? With TOAST?
Дата
Msg-id 2265.982249930@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Max query limit in 7.1? With TOAST?  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Список pgsql-general
Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
> What is the max query size for 7.1?

There's no specific upper limit, and has not been since 7.0.

The reason mysql's crashme test crashes when run against recent Postgres
releases is that it tries to determine the max query string length by
experiment.  Unfortunately, the Perl code they use to do this is more
of a memory hog than the backend itself, and so the Perl process runs
out of memory first.  I have MAXDSIZ set to 128Mb, and I see the Perl
process die with a malloc() failure when the backend is still well under
100Mb.  Not sure what query string length it's testing at that point,
but presumably on the order of ten meg...

            regards, tom lane

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

Предыдущее
От: Guillaume Lémery
Дата:
Сообщение: .TO_CHAR problem
Следующее
От: "Kristoffer Hoffe Bergqvist"
Дата:
Сообщение: DSN-less connection to Postgres-database