Re: [GENERAL] same size VARCHAR or INT IX faster?

2005-09-02 Thread Matthew Peter 
I assumed as much. Now's the time for me to optimize
so I'd rather know and make optimizations accordingly,
than step blindly. Thanks for the reply. As always,
your a big help.

--- Richard Huxton  wrote:

> Matthew Peter wrote:
> > same size VARCHAR or INT IX faster? i assume INT.
> The
> > reason I ask is I was wondering what (if any) is
> the
> > avg delay from one over the other? And benefit of
> one
> > over the other? Thanks.
> 
> If you want numbers, use INT. If you want text use a
> VARCHAR.
> 
> 
> It's probably difficult to come up with speed
> comparisons for "the same 
> size" since varchar will have an overhead for the
> field-length as well 
> as the number of characters.
> 
> Even then, you'd have to account for client language
> and application 
> overheads.
> 
> In any case, optimising at this level is unlikely to
> be a good use of 
> your time unless you really have reached the
> practical limits of 
> available hardware.
> 
> --
>Richard Huxton
>Archonet Ltd
> 
> ---(end of
> broadcast)---
> TIP 5: don't forget to increase your free space map
> settings
> 





Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 
 

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

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

Re: [GENERAL] same size VARCHAR or INT IX faster?

2005-09-02 Thread Richard Huxton 

Matthew Peter wrote:

same size VARCHAR or INT IX faster? i assume INT. The
reason I ask is I was wondering what (if any) is the
avg delay from one over the other? And benefit of one
over the other? Thanks.


If you want numbers, use INT. If you want text use a VARCHAR.


It's probably difficult to come up with speed comparisons for "the same 
size" since varchar will have an overhead for the field-length as well 
as the number of characters.


Even then, you'd have to account for client language and application 
overheads.


In any case, optimising at this level is unlikely to be a good use of 
your time unless you really have reached the practical limits of 
available hardware.


--
  Richard Huxton
  Archonet Ltd

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

[GENERAL] same size VARCHAR or INT IX faster?

2005-09-01 Thread Matthew Peter 
same size VARCHAR or INT IX faster? i assume INT. The
reason I ask is I was wondering what (if any) is the
avg delay from one over the other? And benefit of one
over the other? Thanks.



__ 
Yahoo! Mail 
Stay connected, organized, and protected. Take the tour: 
http://tour.mail.yahoo.com/mailtour.html 


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly