Re: Postgres as In-Memory Database?
| От | Jeff Janes |
|---|---|
| Тема | Re: Postgres as In-Memory Database? |
| Дата | |
| Msg-id | CAMkU=1z6P34DVzdYW7uBF9NA-WePy0jjRtXe1Pi3C7CKRwY+DA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Postgres as In-Memory Database? (Stefan Keller <sfkeller@gmail.com>) |
| Ответы |
Re: Postgres as In-Memory Database?
|
| Список | pgsql-general |
On Sun, Nov 17, 2013 at 4:02 PM, Stefan Keller <sfkeller@gmail.com> wrote:
2013/11/18 Andreas Brandl <ml@3.141592654.de> wrote:> What is your use-case?It's geospatial data from OpenStreetMap stored in a schema optimized for PostGIS extension (produced by osm2pgsql).BTW: Having said (to Martijn) that using Postgres is probably more efficient, than programming an in-memory database in a decent language: OpenStreetMap has a very, very large Node table which is heavily used by other tables (like ways) - and becomes rather slow in Postgres.
Do you know why it is slow? I'd give high odds that it would be a specific implementation detail in the code that is suboptimal, or maybe a design decision of PostGIS, rather than some high level architectural decision of PostgreSQL.
Cheers,
Jeff
В списке pgsql-general по дате отправления: