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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

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.


Pavel Stehule

> --
> View this message in context:
> Sent from the PostgreSQL - performance mailing list archive at
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:

In response to


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-2017 The PostgreSQL Global Development Group