On Jan 19, 2015, at 5:07 PM, Stefan Keller wrote: > Hi > > I'm pretty sure PostgreSQL can handle this. > But since you asked with a theoretic background, > it's probably worthwhile to look at column stores (like [1]).
Wow. I didn't know there was a column store extension for PG -- this would come in handy for some analytic stuff we run! I know that PG can handle my current system "at scale". I'm really just wondering what the possible slowdowns/improvements will be. Doing a rewrite of the entire row + updating the various indexes seems to be a lot of unnecessary IO. At some point it will make sense to minimize that and isolate the heavy-write columns from impacting the rest of the table's performance. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
