From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Carmen Wai" <wai_carmen(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Max length of SQL statement |
Date: | 2003-12-28 16:30:03 |
Message-ID: | 18412.1072629003@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Carmen Wai" <wai_carmen(at)hotmail(dot)com> writes:
> Do any one know the max length of a SQL statement?
There is no specific limit; it'll depend on available memory and
complexity of the statement. I've run tests with multi-megabyte
string literals, tens of thousands of WHERE clauses, etc.
MySQL's "crashme" test program attempts to discover the maximum length
of a SQL statement in the tested database. The last time I tried it,
I was highly amused to watch the test program run out of memory and dump
core before Postgres did. (This was a couple years back, so maybe
they've fixed their problem by now.)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Casey Allen Shobe | 2003-12-28 17:37:58 | Re: Is my MySQL Gaining ? |
Previous Message | Paul Thomas | 2003-12-28 16:20:28 | Re: Is my MySQL Gaining ? |