performance issue in the fields.

From: dba <dbadbb(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: performance issue in the fields.
Date: 2011-02-14 11:33:12
Message-ID: 1297683192310-3384307.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2011-02-14 11:36:50 Re: performance issue in the fields.
Previous Message Artur Zając 2011-02-14 08:09:55 Re: How to boost performance of queries containing pattern matching characters