Hello 2011/2/14 dba <dbadbb@xxxxxxxxx>: > > > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
