On Thu, Apr 23, 2009 at 01:21:05PM +0200, Ivan Sergio Borgonovo wrote:
> I'll try to rephrase to check if I understood and for reference.
>
> varchar is slower than text since it has to do some "data type
> check".
Yes but no. It is said to be slower because it has to do a
data length check, not
essentially you are trying to store a database in a database, and
that's slow for one.
Second, storing things as varchar is space and index (space)
ineffective - and that's another reason to make things slower.
Third - you need to complicate your logic to retrieve data, and that adds up.
text is l
On Thu, 23 Apr 2009 12:00:30 +0200
Karsten Hilbert wrote:
> On Thu, Apr 23, 2009 at 11:33:34AM +0200, Ivan Sergio Borgonovo
> wrote:
>
> > Karsten Hilbert wrote:
> >
> > > On Thu, Apr 23, 2009 at 12:02:13AM +0100, Seref Arikan wrote:
> > >
> > > > I have a set of dynamically composed objects
On Thu, Apr 23, 2009 at 11:33:34AM +0200, Ivan Sergio Borgonovo wrote:
> Karsten Hilbert wrote:
>
> > On Thu, Apr 23, 2009 at 12:02:13AM +0100, Seref Arikan wrote:
> >
> > > I have a set of dynamically composed objects represented in
> > > Java, with string values for various attributes, which
On Thu, 23 Apr 2009 11:00:59 +0200
Karsten Hilbert wrote:
> On Thu, Apr 23, 2009 at 12:02:13AM +0100, Seref Arikan wrote:
>
> > I have a set of dynamically composed objects represented in
> > Java, with string values for various attributes, which have
> > variable length. In case you have sugges
Thanks for elaborating on that Tom. I understand what it means by extension
now.
The reason I looked into it in the first place was because someone at work
said that varchar was an alias for text, which didn't quite sound right.
And I had automatically used the data-type "text" for any varying te
Thom Brown writes:
> The reason I ask is because the documentation says "If character varying is
> used without length specifier, the type accepts strings of any size. The
> latter is a PostgreSQL extension." I wasn't sure if such an extension meant
> there was a level of over-head involved, or r
I see. Thanks for clarifying!
Thom
2009/1/27 Richard Huxton
> Thom Brown wrote:
> > The reason I ask is because the documentation says "If character varying
> is
> > used without length specifier, the type accepts strings of any size. The
> > latter is a PostgreSQL extension." I wasn't sure i
Thom Brown wrote:
> The reason I ask is because the documentation says "If character varying is
> used without length specifier, the type accepts strings of any size. The
> latter is a PostgreSQL extension." I wasn't sure if such an extension meant
> there was a level of over-head involved, or red
The reason I ask is because the documentation says "If character varying is
used without length specifier, the type accepts strings of any size. The
latter is a PostgreSQL extension." I wasn't sure if such an extension meant
there was a level of over-head involved, or reduced its indexability.
20
Is there a real difference between a varchar without a specified length and
the text datatype?
Ow Mun Heng wrote:
Anyhow, searching the archives (in my mail client - no internet at the
moment), I see references that when I use TEXT, I will create TOAST
tables which will have them lie _outside_ of my main data table.
The same is true of varchar, and quite a few other data types. There's
Hi,
I'm a (more than a) bit confuse as to the diference between TEXT and
varchar data-types.
AFAIK, varchar will have a max limit char of, if not mistaken ~65k? But
for TEXT, it's more like a BLOB and there's supposed to be no limit?
Anyhow, searching the archives (in my mail client - no interne
On Tue, Jan 04, 2005 at 09:50:18AM +0200, Sim Zacks wrote:
> Are there any differences between text and varchar? I found the following in
> the docs, which leads me to believe that there are no differences at all.
> Can someone please confirm this before I switch all my varchars to text?
Correct.
Are there any differences between text and varchar? I found the following in
the docs, which leads me to believe that there are no differences at all.
Can someone please confirm this before I switch all my varchars to text?
Tip: There are no performance differences between these three types, apart
15 matches
Mail list logo
