[Tile-serving] Hstore benchmarking results

[Frank Broniewski]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Am 2014-03-06 06:52, schrieb Paul Norman:
> I've released some results of benchmarking of performance with
> hstore on my blog at
> http://www.paulnorman.ca/blog/2014/03/osm2pgsql-and-hstore/
> 
> The short version of the results is
> 
> - Use -k (--hstore), don't use --match-only or -j (--hstore-all)
> 
> - There is very little performance hit for -k
> 
> - There is more of a size increase
> 
> 
> _______________________________________________ Tile-serving
> mailing list Tile-serving at openstreetmap.org 
> https://lists.openstreetmap.org/listinfo/tile-serving
> 

Hi Paul,

I find your test quite interesting, as I am one of the persons who
uses the --hstore-all option for my database. I find it quite
convenient to have the attributes of an geographic object in one
column. Mostly because I only need one index on the hstore column
instead of putting an index on my most required columns.

I was also already thinking of removing most columns from the style
file and only leaving those which are always used and don't require an
index, like name for example.

Well anyways, your number give me something to think about! Thanks for
that.

Frank

- -- 
Frank BRONIEWSKI

METRICO s.à r.l.
géomètres
technologies d'information géographique
rue des Romains 36
L-5433 NIEDERDONVEN

tél.: +352 26 74 94 - 28
fax.: +352 26 74 94 99
http://www.metrico.lu
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJTGCX+AAoJEHopqW0d1cQVEwgIAMQ3RCRpha/HHzrp5nNa4ry4
RXiTMMxWq6rOGMxM38/FuJ8U4FSDRXb/8uSIgaXDWp5UxTrYyDnC8qs3ZoxE8i0K
z3uDtWwlFhspddNUWyBvU6f5TqcebbqX236njrAJG7xmNIGpvX+NHaRhkb4VOA7L
z0bjhvcj7TrwBQQhRIKE3LJuvRMmd1EhoI8wYMbcUR+yaRLW6na/S+SSF/IPRpGL
0ENkj4iyYM3UDAzt9OzXrXfwgVEpu+WCWpPfOeBQfJLir7R4y9LxyMOEmzAqSGME
E76I/D/wMAO8IY1Woz8SjR11GQZ8CrmgxTkrGDJLvFZgZw/ApU/5mBsILdw1c7s=
=lnPE
-----END PGP SIGNATURE-----