Re: postgresql and 'text' prototype
Re: postgresql and 'text' prototype
- Subject: Re: postgresql and 'text' prototype
- From: Helmut Schottmüller <email@hidden>
- Date: Tue, 01 Jul 2008 20:52:29 +0200
Hi,
Am 01.07.2008 um 18:28 schrieb Mike Schrag:
But why are you using TEXT types for small text fields like
firstname. Correct me if I'm wrong but I assume that you have much
more performance and indexing power if you use varchar instead.
from pg manual: "Tip: There are no performance differences between
these three types, apart from the increased storage size when using
the blank-padded type. While character(n) has performance advantages
in some other database systems, it has
no such advantages in PostgreSQL. In most situations text or
character varying should be used instead."
cool, great to read that (and thanks for the correction :-D). In fact
I switched from MySQL to Postgres last year and with MySQL it is
definitely an issue. Especially if you want to use InnoDB tables. Full
text indexing is not available then.
Regards,
HelmutAttachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden