[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] performance issue in the fields.
From:       "Pierre C" <lists () peufeu ! com>
Date:       2011-02-24 8:22:53
Message-ID: op.vreewfeleorkce () apollo13
[Download RAW message or body]


>>> 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.

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]