Search Postgresql Archives

Re: maximum size of plpgsql function parameter

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx> 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.
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux