> will pgsql insert and query faster if i use int2
> compared to char(2)?
Yes, but whether the difference will be perceptible in the context of
your application is difficult to guess. Try testing with some
quick-hack changes to your app.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Keith Worthington||Date: 2005-07-28 18:47:30|
|Subject: Re: Table Design Issue & PGSQL Performance|
|Previous:||From: operationsengineer1||Date: 2005-07-28 17:33:09|
|Subject: Table Design Issue & PGSQL Performance|