Skip site navigation (1) Skip section navigation (2)

Re: performance issue in the fields.

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: dba <dbadbb(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: performance issue in the fields.
Date: 2011-02-14 11:36:50
Message-ID: AANLkTikdU4ZqyMO8L2N_BuGiYf2r3wvhE1AN0mJU38A8@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hello

2011/2/14 dba <dbadbb(at)gmail(dot)com>:
>
>
> 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.

yes, there is. Planner can not to work well with foreign keys stored in array.

Regards

Pavel Stehule

> --
> 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:
> http://www.postgresql.org/mailpref/pgsql-performance
>

In response to

Responses

pgsql-performance by date

Next:From: dbaDate: 2011-02-14 12:06:27
Subject: Field wise checking the performance.
Previous:From: dbaDate: 2011-02-14 11:33:12
Subject: performance issue in the fields.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group