On Fri, Dec 15, 2006 at 07:44:16AM -0600, Ron Johnson wrote: > > The difference in performence will be determined by the cost of > > comparison. The cost of comparing strings is much higher than for > > integers, so it will be slower. > > And comparing INT8 is more expensive on a 32-bit system. The difference between int4 and int8 is probably negligable. > Since TEXT is totally variable, is there a big difference in TEXT vs > CHAR(8)? Nothing measurable I'd think. It's probably the same code. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
