Alvaro Herrera wrote: > (Tom Lane says both SQL92 and SQL99 specify 128 as the maximun > identifier length) > > Anyway, how does one measure the perfomance impact of such a change? > By merely changing the constant definition, or also by actually using > long identifiers? I can do that if it's of any help, for various values > perhaps.
I think I would measure disk size change in a newly created database, and run regression for various values. That uses a lot of identifier lookups. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])