Tips & Tricks
simplify function to simplify complex geometries in your database. This is especially helpful at lower zoom levels where high numbers of vertices aren't necessary.
When performing spatial functions like the simplify example above, be sure that the geometry returned is always in a field named
the_geom. This is the field name that is necessary to create GeoJSON (what Leaflet Vector Layers uses for geometry).