On Fri, Nov 19, 2010 at 12:21 AM, Andreas Kalsch <[email protected]>wrote:
> It's always great to try something new, but we use Postgres as the database > and it is SQL, where I use tables. Somehow I feel forced to learn something > I and others will not use very often. It is better to be conservative about > schemas. The problem: I have written some software that heavily relies on > the 0.36 simple schema. Now I have to use 0.36 and cannot use the new PBF > format. > It would be good to be able to choose between hstore and the old schema > that did my job very well. > What about GROUP BY over single hstore k/v pairs - is this possible? hstore > feels like having a table inside a cell ... > If you don't need the performance or features provided by hstore, then stick with Osmosis 0.36 for now. If you do need new features like PBF binary support you can run two osmosis installs side-by-side and pipe between them if necessary. However if you decide to process a full planet I think you will appreciate the performance gains that hstore provides. Can you give an example of a GROUP BY query you were performing before? Perhaps we can figure out an alternative using the new hstore data type. Note that while the schema is compatible with PostgreSQL 8.3 and later, newer versions provide additional functions that make it easier to convert from hstore to sets and vice versa. Brett
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
