Shall I use PostgreSQL Array Type in The Following Case - Mailing list pgsql-general

From Yan Cheng Cheok
Subject Shall I use PostgreSQL Array Type in The Following Case
Date
Msg-id 908123.20928.qm@web65701.mail.ac4.yahoo.com
Whole thread Raw
Responses Re: Shall I use PostgreSQL Array Type in The Following Case  (Sam Mason <sam@samason.me.uk>)
Re: Shall I use PostgreSQL Array Type in The Following Case  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Re: Shall I use PostgreSQL Array Type in The Following Case  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
I realize there is Array data type for PostgreSQL.

http://www.postgresql.org/docs/8.1/interactive/arrays.html

Currently, I need to use database to store measurement result of a semiconductor factory.

They are producing semicondutor units. Every semicondutor units can have variable number of measurement parameters.

I plan to design the table in the following way.

    SemicondutorComponent
    =====================
    ID |


    Measurement
    =================
    ID | Name | Value | SemicondutorComponent_ID

Example of data :

    SemicondutorComponent
    =====================
    1 |
    2 |

    Measurement
    =================
    1 | Width       | 0.001 | 1
    2 | Height      | 0.021 | 1
    3 | Thickness   | 0.022 | 1
    4 | Pad0_Length | 0.031 | 1
    5 | Pad1_Width  | 0.041 | 1
    6 | Width       | 0.001 | 2
    7 | Height      | 0.021 | 2
    8 | Thickness   | 0.022 | 2
    9 | Pad0_Length | 0.031 | 2
    10| Pad1_Width  | 0.041 | 2
    11| Pad2_Width  | 0.041 | 2
    12| Lead0_Width | 0.041 | 2

Assume a factory is producing 24 million units in 1 day

SemicondutorComponent table will have 24 million rows in 1 day

Assume one SemicondutorComponent unit is having 50 measurement parameters. (can be more or can be less, depending on
SemicondutorComponenttype) 

Measurement table will have 24 * 50 million rows in 1 day

Is it efficient to design that way?

**I wish to have super fast write speed, and reasonable fast read speed from the database.**

Or shall I make use of PostgreSQL Array facility?

    SemicondutorComponent
    =====================
    ID | Array_of_measurement_name | Array_of_measurement_value







pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Save MySQL? HA
Next
From: "donniehan"
Date:
Subject: Re: Some issues about data type convert