| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Ottavio Campana" <ottavio(at)campana(dot)vi(dot)it> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: maximum size of plpgsql function parameter |
| Date: | 2007-11-21 11:52:11 |
| Message-ID: | 162867790711210352id4130e5kf6557d6f73f2469d@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
theoretically there are only limits on data types 1GB. But really big
fields has negative impact on speed (it depends on RAM). If you have
fields bigger than 10-20M, than is better to use BLOBs.
Regards
Pavel Stehule
On 21/11/2007, Ottavio Campana <ottavio(at)campana(dot)vi(dot)it> wrote:
> I want to pass some text to a function which is going to store it for
> some tsearch queries.
>
> Is there a limit on the length of the text I can pass to a function?
>
> --
> Non c'e' piu' forza nella normalita', c'e' solo monotonia.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2007-11-21 12:20:07 | Re: [GENERAL] possible to create multivalued index from xpath() results in 8.3? |
| Previous Message | Alvaro Herrera | 2007-11-21 11:20:18 | Re: PostgreSQL is not behaving consistently across platforms |