News for hackers. Stuff that matters.
Re:Hypothetical Indexes in PostgreSQL by hinkley on Tuesday July 02, 2019 @03:48PM (#20338772)
My C is too awful at this point to get over my impostor syndrome and contribute to Postgres, but I've always been curious about the prospects of scaling Postgres higher by having different indexes on different replicas.

Lacking anything like this, we have to make the OLAP vs OLTP workflow splits sooner than we likely would have. Or at least, for companies that are growing organically. For VC backed companies this may be a difference of only 3-6 months.

Re:Hypothetical Indexes in PostgreSQL by chillydawg on Tuesday July 02, 2019 @04:02PM (#20338912)
Using logical replication you can do this. Effectively, it propragtes only the data changes and you can control the ddl changes. I use this to great effect to have a prod db logically replicating to a data warehouse with different indexes and views AND to a hotstandby via the usual binary wal shipping method.