Question about varchar and text

[Stewart, Robert D]

What is the difference between varchar and text?
I have heard that you can use text instead of varchar and this could speed
up your tables.


Robert Stewart
Network Eng
Governor's Office of Technology
101 Cold Harbor
Work # 502 564 9696
Cell # 502 330 5991
Email [email]RobertD.Stewart@ky.gov[/email]

[Derik Barclay]

I don't know about running faster, but I believe the only difference between
the two in postgres is that a varchar has a limit on input. They are stored
and indexed the same.

On January 6, 2005 12:25 pm, Stewart, Robert D (COT) wrote:

> What is the difference between varchar and text?
> I have heard that you can use text instead of varchar and this could speed
> up your tables.
>
>
> Robert Stewart
> Network Eng
> Governor's Office of Technology
> 101 Cold Harbor
> Work # 502 564 9696
> Cell # 502 330 5991
> Email [email]RobertD.Stewart@ky.gov[/email]

--
Givex - [url]http://www.givex.com/[/url]
Derik Barclay <dbarclay@givex.com>, Systems Software Engineer
+1 416 350 9660
+1 416 250 9661 (fax)

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [email]majordomo@postgresql.org[/email])

[Thomas Braad Toft]

Hi!

Stewart, Robert D (COT) wrote:

> What is the difference between varchar and text?
>
> I have heard that you can use text instead of varchar and this could

speed up your tables.


[url]http://www.postgresql.org/docs/7.4/interactive/datatype-character.html[/url]

Quote: "Tip: There are no performance differences between these three
types, apart from the increased storage size when using the blank-padded
type."

--
Thomas Braad Toft

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

[url]http://archives.postgresql.org[/url]

[Joshua D. Drake]

Derik Barclay wrote:

> I don't know about running faster, but I believe the only difference between
> the two in postgres is that a varchar has a limit on input. They are stored
> and indexed the same.

There is a theory that text is faster than varchar, because postgresql
doesn't have to check text. So it is one less thing for PostgreSQL to do
before it provides the tuple.

J

>
> On January 6, 2005 12:25 pm, Stewart, Robert D (COT) wrote:
>

>>What is the difference between varchar and text?
>>I have heard that you can use text instead of varchar and this could speed
>>up your tables.
>>
>>
>>Robert Stewart
>>Network Eng
>>Governor's Office of Technology
>>101 Cold Harbor
>>Work # 502 564 9696
>>Cell # 502 330 5991
>>Email [email]RobertD.Stewart@ky.gov[/email]

>
>

--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [email]jd@commandprompt.com[/email] - [url]http://www.commandprompt.com[/url]
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [email]majordomo@postgresql.org[/email])