Max query limit in 7.1? With TOAST?

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: pgsql-general(at)postgresql(dot)org
Subject: Max query limit in 7.1? With TOAST?
Date: 2001-02-15 06:56:50
Message-ID: 3.0.5.32.20010215145650.008f98c0@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaw Terwilliger 2001-02-15 07:05:09 ALTER TABLE speed (adding foreign keys)
Previous Message Michael Fork 2001-02-15 06:16:19 Re: Case insensitive selects?