Use Postgres as a column store by creating one table per column

Lev Kokotov <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <CAPwLVyJJ_ePn7O3PoMjSTJ64w=0RY2vGu4BfHRG58krC1Gkdcw@mail.gmail.com>
Is it efficient to use Postgres as a column store by creating one table per
column?

I would query it with something like `[...] UNION SELECT value AS <table>
FROM <table> WHERE value = <value> UNION [...]` to build a row.

I'm thinking since Postgres stores tables in continuous blocks of 16MB each
(I think that's the default page size?) I would get efficient reads and
with parallel queries I could benefit from multiple cores.

Thanks!

Best,
Lev
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.