Thread: Max query limit in 7.1? With TOAST?

Hi,

What is the max query size for 7.1?

For 6.5.x it's about 16383 bytes.

The reason why I'm wondering is because I'm thinking of using 7.1's TOAST
to insert large amounts of text into a table (e.g. > 1MB). And I'd like to
confirm that it's possible using the usual database interfaces and methods
e.g. INSERT/UPDATE over ODBC/DBI/PHP-PG. Because if it's not possible yet,
then I'll store the stuff on the filesystem.

Thanks,
Link.

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