2011/2/14 dba <dbadbb(at)gmail(dot)com>:
> create table a( address1 int,address2 int,address3 int)
> create table b(address int)
> 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.
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-performance by date
|Next:||From: dba||Date: 2011-02-14 12:06:27|
|Subject: Field wise checking the performance.|
|Previous:||From: dba||Date: 2011-02-14 11:33:12|
|Subject: performance issue in the fields.|