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

On Tue, 21 May 2019 21:28:07 -0700, Lev Kokotov wrote: >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 >FROM WHERE value = UNION [...]` to build a row. I think you mean JOIN. You'd

Re: Why HDD performance is better than SSD in this case

On Wed, 18 Jul 2018 09:46:32 +0200, Fabio Pardi wrote: RAID 0 to store production data should never be used. Never a good idea, in my opinion. RAID 0  by itself  should never be used.  Combined with other RAID levels, it can boost performance without sacrificing reliability. https://en.wiki