Re: Table Design Issue & PGSQL Performance - Mailing list pgsql-novice

From Tom Lane
Subject Re: Table Design Issue & PGSQL Performance
Date
Msg-id 25806.1122574915@sss.pgh.pa.us
Whole thread Raw
In response to Table Design Issue & PGSQL Performance  (<operationsengineer1@yahoo.com>)
List pgsql-novice
<operationsengineer1@yahoo.com> writes:
> 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

pgsql-novice by date:

Previous
From:
Date:
Subject: Table Design Issue & PGSQL Performance
Next
From: "Keith Worthington"
Date:
Subject: Re: Table Design Issue & PGSQL Performance