|
|
|
|
|
|
by malkia
4989 days ago
|
|
|
Today was my first real usage of PostGres (moving one of our assetdb from sqlite to it, and although the update of the db is 5 time slower - well I haven't really done well there, the query later (which is more important) is from 1.5sec to 300msec on one recent example - about 100,000 assets for a video game). I've also looked briefly about fdw, as a coworker of mine is trying out mongodb for our level editor... Looked at all implementation and read the every fdw code there (except oracle - as it seems most complex, but for good I guess - it checks the pgsql's AST (is that how it's called?) more deeply). As for redis, maybe this line is relevant: https://github.com/dpage/redis_fdw/blob/master/redis_fdw.c#L... yes, for certain cases (I guess "select ") it does "keys ". I'm also trying out redis for our distributed caching in the studio. So PostGres is my new favourite thing :) - the fdw looks easy to start, but probably hard to master it. |
|
|
Then let us welcome you with some pedantry! Postgres or PostgreSQL, but never PostGres or--FSM forbid--PostGreSQL.
More seriously,
> fdw looks easy to start, but probably hard to master it.
Yep, like a number of Postgres features, such as user-defined types and user-defined aggregates. It's a great system, and not nearly as stuffy or hard to use as you may have heard.