[postgis-users] Grid of points inside Polygon

[Rémi Cura]

Also if you do have indexes,
can you run a "VACUUM ANALYZE", so that the indexes will be used?

Cheers,

Rémi-C


2013/11/15 Rémi Cura <remi.cura at gmail.com>

> It should be finished by now,
> can you check you have geom indexes on :
> "ukmajrdbuffer.geom" and  "all_lines.the_geom"
>
>
> How many geoms do you have in "ukmajrdbuffer"?
>
> Cheers,
> Rémi-C
>
>
> 2013/11/15 Rémi Cura <remi.cura at gmail.com>
>
>> Hey Sandro,
>>
>> Thanks for this, it is at least twice faster =)
>>
>> Cheers,
>> Rémi-C
>>
>>
>>
>>
>> 2013/11/15 James David Smith <james.david.smith at gmail.com>
>>
>>> Thanks both. Geometries now fixed.
>>>
>>> The query 'CREATE TABLE lines_for_each_road....' has now been set
>>> running. Will report back when it's done. I suspect it may take a
>>> while!
>>>
>>> James
>>>
>>> On 15 November 2013 11:03, Sandro Santilli <strk at keybit.net> wrote:
>>> > On Fri, Nov 15, 2013 at 11:50:42AM +0100, Rémi Cura wrote:
>>> >> Yep, maybe something like
>>> >>
>>> >> UPDATE ukmajrdbuffer SET the_geom = ST_MakeValid(the_geom)
>>> >> WHERE ST_IsValid(the_geom) = FALSE
>>> >
>>> > ST_MakeValid internally checks for ST_IsValid, so no need
>>> > to add the condition (which would run the test twice).
>>> >
>>> > --strk;
>>> > _______________________________________________
>>> > postgis-users mailing list
>>> > postgis-users at lists.osgeo.org
>>> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131115/f8610dd6/attachment.html>