From: | Pat Trainor <pat(dot)trainor(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | How To: A large [2D] matrix, 100,000+ rows/columns |
Date: | 2023-06-09 02:17:59 |
Message-ID: | CAK_m+w=zf1mLP4+N+rNDaG5xU1_MjqTUDYbf+D-RyiF4ek5mQw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
number is at each X-Y (row/column), and that is the big picture. 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?
By wanting postgresql as a solution, am I round-hole, square-pegging myself?
I don't mind keeping, say, a 1,500 column max per table, but then adding
new items (stocks in the above analogy) might make it difficult to keep
track of things...
Hoping someone has tackled this before, and performance isn't too big a
concern, as the data changes seldom.
I know it's a weird one, so thanks!
:-)
From | Date | Subject | |
---|---|---|---|
Next Message | shveta malik | 2023-06-09 03:10:40 | Re: Support logical replication of DDLs |
Previous Message | Masahiko Sawada | 2023-06-09 00:05:08 | Re: Support logical replication of DDLs |