From: Pierre C <lists@peufeu.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: dba <dbadbb@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: performance issue in the fields.
Date: Thu, 24 Feb 2011 09:22:53 +0100
Message-ID: <op.vreewfeleorkce@apollo13> (raw)
In-Reply-To: <AANLkTin=SapzXFu0ip_Fw4H6Wa_+a3CNGbXD17XKOQNY@mail.gmail.com>
References: <1297683192310-3384307.post@n5.nabble.com>
<AANLkTikdU4ZqyMO8L2N_BuGiYf2r3wvhE1AN0mJU38A8@mail.gmail.com>
<AANLkTin=SapzXFu0ip_Fw4H6Wa_+a3CNGbXD17XKOQNY@mail.gmail.com>
>>> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@peufeu.com, pavel.stehule@gmail.com, mmoncure@gmail.com, dbadbb@gmail.com
Subject: Re: performance issue in the fields.
In-Reply-To: <op.vreewfeleorkce@apollo13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox