Changes between Initial Version and Version 1 of Ticket #4739, comment 2


Ignore:
Timestamp:
Oct 2, 2020, 3:55:36 AM (4 years ago)
Author:
ansel

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #4739, comment 2

    initial v1  
    2525create index on t using gist (c);
    2626select 1 from t where postgis.st_dwithin(postgis.st_geomfromtext('POINT(3373062 5626876)'::text, 31467), c, 1000.);
     27create materialized view v as SELECT * FROM t WHERE postgis.st_dwithin(postgis.st_geomfromtext('POINT(3373062 5626876)'::text, 31467), c, 1000.);
    2728}}}
    2829