Max query limit in 7.1? With TOAST? - Mailing list pgsql-general

From Lincoln Yeoh
Subject Max query limit in 7.1? With TOAST?
Date
Msg-id 3.0.5.32.20010215145650.008f98c0@192.228.128.13
Whole thread Raw
Responses Re: Max query limit in 7.1? With TOAST?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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.



pgsql-general by date:

Previous
From: Michael Fork
Date:
Subject: Re: Case insensitive selects?
Next
From: Shaw Terwilliger
Date:
Subject: ALTER TABLE speed (adding foreign keys)