Re: How To: A large [2D] matrix, 100,000+ rows/columns

2023-06-09 Thread Erik Wienhold
> On 09/06/2023 16:00 CEST Wim Bertels wrote: > > Joe Conway schreef op vr 09-06-2023 om 09:16 [-0400]: > > On 6/8/23 22:17, Pat Trainor wrote: > > > I need to have a very large matrix to maintain & query, and if not > > > (1,600 column limit), then how could such data be broken down to > > > work

Re: How To: A large [2D] matrix, 100,000+ rows/columns

2023-06-09 Thread Wim Bertels
Joe Conway schreef op vr 09-06-2023 om 09:16 [-0400]: > On 6/8/23 22:17, Pat Trainor wrote: > > I need to have a very large matrix to maintain & query, and if not > > (1,600 column limit), then how could such data be broken down to > > work? > >   100,000 rows * >   100,000 columns * >   8 bytes

Re: How To: A large [2D] matrix, 100,000+ rows/columns

2023-06-09 Thread Joe Conway
On 6/8/23 22:17, Pat Trainor wrote: Imagine something akin to stocks, where you have a row for every stock, and a column for every stock. Except where the same stock is the row & col, a number is at each X-Y (row/column), and that is the big picture. I need to have a very large matrix to mainta

Re: How To: A large [2D] matrix, 100,000+ rows/columns

2023-06-09 Thread Alban Hertroys
> On 9 Jun 2023, at 04:17, Pat Trainor wrote: (…) > Imagine something akin to stocks, where you have a row for every stock, and a > column for every stock. Except where the same stock is the row & col, a > number is at each X-Y (row/column), and that is the big picture. I need to > have a v

How To: A large [2D] matrix, 100,000+ rows/columns

2023-06-08 Thread Pat Trainor
Experts, A very high level question... Subject sums it up. I love PGSQL, but I don't know if it is a good fit for this back-end... I hope it is. Imagine something akin to stocks, where you have a row for every stock, and a column for every stock. Except where the same stock is the row & col, a