>>> 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.
>>> there any issue would face in performance related things.... which one
>>> cause the performance issue.
The array is interesting :
- if you put a gist index on it and do searches like "array contains
values X and Y and Z", gist index has a some special optimizations for this
- if you might store a variable number of integers, and for some reason
you don't want a normalized one-line-per-value approach
In response to
pgsql-performance by date
|Next:||From: Mathieu De Zutter||Date: 2011-02-24 09:47:07|
|Subject: Re: NULLS LAST performance|
|Previous:||From: Dave Johansen||Date: 2011-02-24 04:10:31|
|Subject: Pushing IN (subquery) down through UNION ALL?|