Re: get array data with range - Mailing list pgsql-sql

From CoL
Subject Re: get array data with range
Date
Msg-id 3C56BE5B.9080509@mportal.hu
Whole thread Raw
In response to get array data with range  ("Johny Jugianto" <johny.q@rocketmail.com>)
List pgsql-sql
Hi,

> second question.
> 2. which are better (from speed and size side)?
> i make "one" table with array like this
> TABLE mytable
> mytable_id         |  array_data
> -------------------------------------
> 1                       | {1,2,...,100000}
> 2                       | {1,2,...,100000}
> 3                       | {1,2,...,100000}
> ....
> 
> or like this one, many table but no array
> TABLE mytable_1
> was_array_data
> ----------------
> 1
> 2
> ...
> 100000
if you have only these numbers in array better to use more tables with 
an int,
cause it can be indexed and fast selected.

CoL



pgsql-sql by date:

Previous
From: "Steve Brett"
Date:
Subject: Re: Index Management
Next
From: alla@sergey.com (Alla)
Date:
Subject: What's wrong with this function - "returns setof"