Postgres Pro
Downloads
Home   >   mailing lists

Thread: Text vs. Varchar talking about performance

Text vs. Varchar talking about performance

From
"Charles N. Charotti"
Date:
Hi everybody,

I'm just wondering what implementation is better in terms of performance specially in the actual parameter passing between functions when using PL/pgSQL, Text parameters or Varchar ones ?

Best regards

Chuck

Re: Text vs. Varchar talking about performance

From
Scott Marlowe
Date:
On Tue, Apr 7, 2009 at 10:23 AM, Charles N. Charotti
<ccharotti@yahoo.com> wrote:
> Hi everybody,
>
> I'm just wondering what implementation is better in terms of performance
> specially in the actual parameter passing between functions when using
> PL/pgSQL, Text parameters or Varchar ones ?

They are the same.

Re: Text vs. Varchar talking about performance

From
"Charles N. Charotti"
Date:
Thank you very much Scott. I got a pretty good explanation here. http://www.postgresql.org/docs/8.3/static/datatype-character.html

Have a good day.

Chuck

--- El mar, 7/4/09, Scott Marlowe <scott.marlowe@gmail.com> escribió:
De: Scott Marlowe <scott.marlowe@gmail.com>
Asunto: Re: [ADMIN] Text vs. Varchar talking about performance
Para: ccharotti@yahoo.com
CC: pgsql-admin@postgresql.org, "Claudio Lezcano" <claudiogmi@gmail.com>, "Fernando Araya" <faraya@promix.tie.cl>, "Fernando Araya" <faal.28@gmail.com>
Fecha: martes, 7 abril, 2009 12:43

On Tue, Apr 7, 2009 at 10:23 AM, Charles N. Charotti
<ccharotti@yahoo.com> wrote:
> Hi everybody,
>
> I'm justwondering what implementation is better in terms of
performance
> specially in the actual parameter passing between functions when using
> PL/pgSQL, Text parameters or Varchar ones ?

They are the same.