Hello 2011/2/14 dba <dba...@gmail.com>: > > > create table a( address1 int,address2 int,address3 int) > create table b(address int[3]) > > I have created two tables. In the first table i am using many fields to > store 3 address. > as well as in b table, i am using array data type to store 3 address. is > there any issue would face in performance related things.... which one will > cause the performance issue.
yes, there is. Planner can not to work well with foreign keys stored in array. Regards Pavel Stehule > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/performance-issue-in-the-fields-tp3384307p3384307.html > Sent from the PostgreSQL - performance mailing list archive at Nabble.com. > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
