3 ms·
That adds quite a bit of latency to your database, which is already frequently the bottleneck. In reality, most of what Mongo does can be done just as well if
by rjbrock 12y ago
That adds quite a bit of latency to your database, which is already frequently the bottleneck.
In reality, most of what Mongo does can be done just as well if not better in Postgresql 9.3 (and I hear good things about 9.4). Then you can simultaneously have structured data via postgres
- Sanddancer 12y agoI don't think the parent's talking about doing all operations via the fdw, but rather using the foreign data wrapper to fill the table. So instead of pulling all the data into a python script and then pumping it out into the postgresql database, you're using postgresql itself to do the fill operation. Additionally, by using the foreign data wrapper, you could also create a materialized view based on the results, if you still want most activities using the mongodb instances for whatever reason.