Search Postgresql Archives

Re: Pl/PgsSQL array

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Richard Huxton wrote:
Ben-Nes Yonatan wrote:

Richard Huxton wrote:

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 would be tempted use an external perl script to receive the data and insert it into the database, building the categories tree as it did so.

--
  Richard Huxton
  Archonet Ltd

Sadly im not familiar with Perl...

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux