Re: Pl/PgsSQL array - Mailing list pgsql-general

From Ben-Nes Yonatan
Subject Re: Pl/PgsSQL array
Date
Msg-id 42CC1A67.7020407@canaan.co.il
Whole thread Raw
In response to Re: Pl/PgsSQL array  (Richard Huxton <dev@archonet.com>)
Responses Re: Pl/PgsSQL array
List pgsql-general
Richard Huxton wrote:
> Ben-Nes Yonatan wrote:
>
>> Hi all,
>>
>> Can anyone tell me if Pl/PgSQL can support a multi dimensional array
>> (of up to 5 levels top I guess) with about 100,000 values?
>> and does it stress the system too much?
>
>
> I can't imagine it being wonderful - you probably want a different
> procedural language. Or a different approach come to think of it - can I
> ask what you are using 5D arrays with 100,000 values for?
>

Indeed you can my good sir :)

Im going to insert into one table a list of about 3.5 million products
each day, thouse products also contain data about their own categories.

Now I receive all of this data every day and I need to delete all of the
previous data each time and insert the new one.
In order to create the category table (tree table) I want to create an
array out of the categories information at the products and then insert
it into the the categories table (the tree :)).

I also thought about retrieving the data from the products table and
inserting it first into a temporary table and from that information
create the categories table (tree :)), but I prefer to save the next
selects from that table and just create an array.

Maybe you or anyone else got a better idea?

Thanks again!

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Pl/PgsSQL array
Next
From: Joe Markwardt
Date:
Subject: Re: ERROR: cache lookup failed for relation 438095645